Excel data to master sheet from multiple sheets

Question

I am creating a rota/daily tasks sheet.

I have a master sheet for everyday and an individual sheet for each employee.

I have put a drop down option on each master sheet which I would like it to automatically input that persons daily tasks.

I have managed to get this to work for 1 employee using the ‘IF’ formula and a key page.

So for example on the Monday sheet I have put the formula =IF(cell D1=employee1, employee1 personal sheet) this brings the correct data. However I want it to apply to all employee names and sheets.

If this doesn’t make any sense I am happy to forward the worksheet so you can see what I mean.

Thanks

Answer 1

Thanks. See the modified version at https://www.dropbox.com/scl/fi/ls0ygsgllg5pf5k9klgyc/Rota.xlsx?rlkey=ckeq5dpqcr9irt7r1ttykdcl3&dl=1

Answer 2

Rota.xlsx

At the moment I have only done Monday master sheet and 2 employee sheets but there will be up to 15 employees to be added and a master sheet for each day.

Thanks

Answer 3

I'd have to know more about the layout of the workbook.

Could you create a stripped-down copy of the workbook demonstrating the problem (without sensitive information) and make it available through one of the websites that let you upload and share a file, such as OneDrive, Google Drive, FileDropper or DropBox. Then post a link to the uploaded and shared file here.

Answer 4

How would I do this formula to link to the drop-down ?

Thanks

Answer 5

Perhaps you can use the INDIRECT function to retrieve data from worksheets whose names are listed on the master sheet.