Is there a way to use a variable in the path of a link. I would like to be
able to define the variable by typing it is a specific cell then update all
my links accordingly

For example say I have workbooks named pOffice22, pOffice23 etc in a
folder. All of these files are the same except they contain data from
different weeks. I have a summary workbook that I use to perform various
reports on this data. The data is transferred into the summary workbook via
links.

I would like to be able to type 22 in a cell and get the data from file
pOffice 22 or type 23 in the cell and get the data from file pOffice23.

Any help will be greatly appreciated
Christy