I need to develop an Excel macro or? whereby I have one file that acts as a "master" for other files in the following ways:
1. The master file keeps a list of proposal numbers.
2. The other files will be proposals based on a blank template
3. When a user opens the blank template file, it pulls the next proposal number off the master, and is then linked to the master to track certain fields in the proposal file. When the proposal file is saved, it is a new file.

Can this be done and how? Any help is appreciated.