Hi,

I have a problem in that I am trying to collate all sheets in a workbook into a summary sheet (apart from a sheet named "Guidance" and the summary sheet itself, named "Database").

The target cells are C6:F6 on every sheet apart form the previously mentioned. The destination cells are B10:E10.

Effectively, I am trying to create a list on the summary sheet, which enters the new data from C6:F6 into the list everytime a new worksheet is created.

The code I am using currently seems to return an error that I am unable to fix.

Please Login or Register  to view this content.
Any help would be greatly appreciated.

I am relatively new to VBA, and have copied the above text from another source and tried to adapt.