VBA - Number of worksheet into one summary file

[RR786]

Hi Everyone

Wondering if you can help I am trying to create a consolidate button

I have a summary tab called 'Summary' and trying to consolidate number of worksheets in the same file into one

I want it to be able to clear the summary and then copy and paste info from worksheet 1,2,3,4,5,6 etc. into summary from where the first row of info starts from after header which is like on row 8 and then up to the point there is info and then move to next work sheet - the worksheets all have different levels of info in rows so its being able to pick that up.

does anyone have a VBA i can use

Thanks

 

[sijpie]

Have you searched this forum for examples? It is one of the most commonly asked questions.