Help on designing a workbook

I feel like I am being a massive paid in the rear here....

I have shown that demo to the people who manage the site, and it's not quite what they are after. They have given me a version of the spreadsheet they are using now (with only 2 days on instead of the usual 12-15). What they want is to be able to auto-populate the first page with the wages of each cleaner - if they worked - on the correct day.

Is this possible? The spreadsheet itself will no doubt give you an idea of what we ourselves are able to do with excel.