Hi

I'm starting with a Spreadsheet that is being used to represent the
financial and audit information for individual projects. 1 spreadsheet
document = 1 project.

I have a worksheet that is linked to an Access Database. I need the
information from this Spreadsheet Document to be filtered into a Formatted
Worksheet within another Spreadsheet Document.
Currently I have the Worksheets (linked and formatted) in the same document
and I am using a VLOOKUP format to transfer the information.

However my problem occurs - because I need to 'save as' so that each
individual project is represented by one document. However the original link
to the access database - is not saved when I save as. Therefore I can only
create one project document at a time - when I actually need something close
to 300 documents linked to the database.

My original plan was to Mail Merge the Linked Worksheet to the formatted
worksheet - therefore creating multiple merges to the Linked Worksheet. But I
can't work out how to do this between two Spreadsheet documents - Is this
Possible At All?????

I guess my question is

IS THERE A WAY TO LINK OR MERGE TWO SEPARATE SPREADSHEETS TOGETHER???

Thanks in advance - I hope

Rebecca