I have a XLS with two sheets, ROTA and SETUP
Setup consists of some cells refering to the location of a file called COMPANY ROTA.XLS (EG c:/..../..../).
Setup also decifers what week it is and creates the references it would need to pull back the rota'ed hours for that week and following...