consolidate 75 workbooks - identical headings

[lray]

I have 75 seperate worksheets with 505 columns (A-SK) of identical headings (1-25 rows) of different information i need to consolidate into 1 worksheet. HELP

I need the easy way to do this....Like: create master click, paste code click, and combine sheets click.

I can do it in my mind but haven't found the right code yet on this forum

Thanks, Lray

[alansidman]

I think that this is what you are looking for.

http://www.youtube.com/watch?v=o7RRqVmAc6Q&feature=fvst

Alan