Combine several Worksheet automatically with a macro?

[RCMetrics]

Hi,

say I have a workbook with 10-15 worksheets

All worksheets have the same headers, they just represent different locations.

What would be the code or macro to copy each one into one worksheet rather than copying and pasting everytime.

This is how the workbook is received and it's on a weekly basis... so getting anoying.

So it would go through each sheet, take line 2 to (what ever the amout there is in the worksheet) and get that into another one, then repeat the process for each worksheet till it has done all of them?

Thanks

 

[sja]

SORTED! I needed to use >= 30 as thats why the data in line 30 wasnt being picked up.. Easy once you think about it.. Thanks for the help, really appreciate it..

regards

s