Consolidate Multiple Sheets into Master

Ok, I have a code that is working great, except for two things. I'd like to have the information on the Summary sheet start on Row 6, and have the names of the worksheets the info came from in Column A.

Code is as follows

Please Login or Register  to view this content.

Also would like to have the Summary automatically update if I enter new data into the individual sheets, and to know, if I format the Summary sheet previously to running the macro, will it keep the formatting? (ex. hide columns etc)

I hope this is enough information, and any help will be greatly appreciated.

Thanks in advance!!

This line is copying

Please Login or Register  to view this content.

in to first empty column "B" of summary sheet, which is probably "B1". If you wish the copy to start at Rows 6, the easiset option would be to fill in data(Suspect heading) in "B1-B5", so that the next empyt would become B6.

Thank you, AB33!
That's perfect

Now I just need to figure out how to get the sheet names in column A, and I can probably clear all the data from "Summary" before re-running the macro to update, instead of having it go automatically.

Thanks again!

Yes, I am afraid. I had a discussion on this forum regarding automatic update. It is not shared by the most experienced users of VBA

Please Login or Register  to view this content.

Slightly improved code

Please Login or Register  to view this content.

Oh, you're a genius!

Unfortunately it seems to be over-copying the sheet names, and is copying row 5 from some sheets. Would it be easier if I uploaded a copy of my WB for you to see what I'm trying to do?

Yes, post the whole book

SO close! Now all I need is for it to not copy the 'empty' rows. I can't say enough how much I appreciate all your help. This would've taken me weeks to get this far :D

Thank you SO So much, that is perfect!

You are welcome!
Could you please close this thread as closed?