copy and paste data only to a new file

[Fawn Lagimodiere]

I have 50 different files with one master worksheet in each. What I want to
do is to copy and paste the master sheet from 50 different files into one
new workbook so that I can link the data to access.

Is this possible?

thanks

 

[Vacuum Sealed]

I have 50 different files with one master worksheet in each. What I want to
do is to copy and paste the master sheet from 50 different files into one
new workbook so that I can link the data to access.

Is this possible?

thanks

Hi Fawn

Try these links from Ron DeBruin

http://www.rondebruin.nl/copy3.htm
http://www.rondebruin.nl/fso.htm

HTH
Mick.