I have an employee's name in cell A5 on a SS called Repair rotas.xls on the
Plymouth Staff tab.
The Saturday rota for this employee, called 'Saturday C', is in cell D5.

The spreadsheet on whicih I wish to input this rota is called 'Scheduling
Pots' and Amy Banks is located in cell D1588 and the cell in which I want to
input 'Saturday C' is AQ1588.

Do I use VLOOKUP to get this result and, if so, what would be the form of
this function to return the above result?

Many thanks.