EXCEL MACRO - consolidate multple workbooks in one sheet

[ginninagla]

Hi I need a macro that will go through my specified path and it subfolders and loop through all excel file and then copy them into one spreadsheet. please help...i found lots of similar threads. but none of them work for me.

[protonLeah]

This is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch. This forum is about helping people learn how to use Excel, not a free development service.

Have you started any work on this project yet?
How far did you get?
Where are you stuck?

We can help you develop your own code, but if you want someone to code this for you all the way, you should try and find a commercial developer.