I have a weekly task where i need to report progress on 17 asset areas each
with 7 of their own workbooks, progress is simply looking at number of null
cells per workbook etc. The problem being that each of the workbooks have
been split up to make the size of the data more manageable. Depending on the
workbook some have been split into 40 tabs!

So rather than running the progress macro on each of the 40 tabs i want to
some way copy each of the tabs and dump this into one tab and then run the
progress macro.

Any help would be great - if this could be completed through some sort of
macro it would be brilliant. Each of the s/s have the same number of columns
etc

Cheers Pete