linking worksheets to a closed workbook

[LLK]

I have a workbook which I want each worksheet within it to update from a
master workbook that is closed. The worksheets in the master are updated
often with new info and columns are added and / or deleted with each update.
What I need is for the destination worksheets, when opened, to update to be
exact duplicates in every way from the worksheets in the master/source
workbooks.

Thanks for your help.

 

[Pete_UK]

Why not just open the Master/Source workbook and then immediately use
File | Save As and save the file with a different name?

Hope this helps.

Pete

 

[ryguy7272]

Take a look at this:
http://www.rondebruin.nl/tips.htm

and specifically this:
http://www.rondebruin.nl/ado.htm


Regards,
Ryan---