Merging worksheets in a workbook

[sheilahughes98]

I have 200+ workbooks, each with 3 sheets. I need all the
information for each workbook on 1 worksheet. Can anyone
advise?

TIA

 

[Frank Kabel]

Hi
have a look at the following site as a starting point
http://www.rondebruin.nl/copy3.htm

 

[Ron de Bruin]

Hi Frank

She posted this in Misc

but I'm afraid I don't use VB

I ask here wy?
Maybe she think she need Visual Basic?

 

[Frank Kabel]

Hi ron
just saw your reply to her in Excel.misc. Interested in her response