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

On 28/01/2012 6:48 PM, Fawn Lagimodiere wrote:
> 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.