Help me with macro to collate data from circa 80 excel workbooks

[tommyryan1]

I have approx 80 users completing 1 excel workbook with 7 sheet tabs by way of a timesheet. I know there is a macro that I can use so that I can have the macro in a master document that looks into the specfied folder location where the 80 workbooks are saved and takes all the data from the sheets 1-7 and collates into the master document sheets 1-7. So essentially I each week I would open the master, run the macro and it would consolodate all the data from the 80 books onto my master. I know it can be done as a previous employer used this method, however I have little vba or macro code writing skills and was hoping someone could help me out here?

I am sorry if this has been answered already but I searched and searched and whilst there are answers in the site, they are far too complex for me

Can you help? Please

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.