Hi everyone - newbie to the forum - would like to take this opportunity to thank anyone in advance for any help you could offer.

OK, i have an XLS that has kind of grown over the years. It is used to price buildings and has multiple tabs (worksheets) that have very many linked cells between different worksheets. Some cells even look up data from external files.

One of the worksheets is a "main" sheet with a more 'pretty' user friendly front end which is used by people doing quotes.

The problem i have currently is that there is one 'master' XLS that when necessary, have the product prices changed when supplier prices go up & down.

The individual quotes for jobs get saved (save as) into a specific folder under the clients name & quote number.

Problem is the data in those old quotes only have the prices as current at the time the quote was done.

I want to seperate this XLS into seperate files so that the "main" worksheet is stand alone and when saved as a quote and reopened would look at the most current seperate data XLS files......or better still ask whether to use prices as applicable when quote was done or use most current.

Is this possible with excel, is there a place in tools|options (that i can't find) that says "look for data in a certain folder", like linked tables in access.

Again thanks in advance.