I am having a problem using Hyperlinks within a €œPre Scripted€� Macro.

I have successfully placed a €œFixed€� Hyperlink in a Macro, but I need that
Hyperlink to be a variable; let me explain:

I have created an Excel spreadsheet as a master with the following name:
€œUS-MAS-000-08 Excel-Master€�

With each new customer order I need to open the €œExcel-Master€�, and through
a Macro I open a separate workbook named €œMaster Sequence File 2008€� and grab
the next number in sequence. After I have that number I rename the
€œExcel-Master€� so as to reference the customer. Here are some examples:

€œUS-MAS-001-08 Logistics Kit 10€�
€œUS-MAS-002-08 Elizabeth City Kit 2€�
€œUS-MAS-003-08 Elizabeth City Kit 66€�
€œUS-MAS-004-08 SE OPU-HP€�

As you can see, I have a numerical sequence from 001 thru 004 with the
customers name at the end. Now, after the new €œUS-MAS€� file has been created
I will need to retrieve additional sequence numbers from the €œMaster Sequence
File 2008€� and place them within the €œUS-MAS€� from which I am working.

Here is my problem. I need to open €œUS-MAS-001-08 Logistics Kit 10€�, click
on a Macro Button that takes me to the file €œMaster Sequence File 2008€�,
grads the next €œInvoice #€� (for example) in sequence, then returns me to
€œUS-MAS-001-08 Logistics Kit 10€� so that I can use the new #. Each time I try
to run the Macro it takes me back to the €œUS-MAS-000-08 Excel-Master€� file
because that is the file I used when I created the Macro. I do not know
enough about VBA code to resolve my issue.

Can someone help?