I have information held in a separate worksheet and the name of the worksheet
is changing constantly. Within a cell on my current worksheet I have the
file details of where the information I require is to be obtained. I want to
create a formula that takes the file details from the cell above and adds it
to the formula so it knows where to find the information i require