One Sheet referres to many workbooks
 

I have several workbooks that will be checking on another workbook to
see if there is a match, it's just a small part of the program,
What is really happening is when a product gets ordered, and there is a
match, a little note will be printed on the production page to check
outside and see if you can use this one, before you build a new one.
The match program is in VBA
With one workbook I was going to just link the cell together.

How can I get all the worksheets linked to the one workbook?