VBA Code to collate data from a nr of s/s and insert in one s/s

[NPike]

Each month I get circa 30 workbooks with cost data in, split by tabs in to cost heads, such as; Staff, Materials, Plant, Subcontract ...etc.

I need to collate all the cost data for each cost head into one workbook (that is a separate workbook for each cost head).

At the moment this is taking me ages to collate the information and I was wondering if anyone knew of a Macro which will be able to do this?

More information;

- The circa 30 spreadsheets will be in one Folder on my computer with nothing else in that folder.

- There will be a number of tabs relating to each cost head, e.g. Staff 01, Staff 02, Staff 03 ...etc.

- On each tab, the information I want to collate always starts in cell C3, but will differ in the number of columns from that point, and the number of rows from that point.

Please can anybody help? If you require more information please let me know.

Many thanks in advance if anyone can help!!!

 

[Tinbendr]

Maybe a visit to Ron's page will help.