Hi,
My current problem is I look after a team of drivers we have an excel document, the first tab is a table. The other 10 tabs are delivery sheets one for each driver named individually for them with various cells that display information, these cells are linked to the first tab just by =formulas to the information in the table on the first tab.

My problem is the table shows the drivers name and then horizontally across the line the details of vehicle, shift, etc. I have to manually adjust these details on a daily basis, I would like to have a cell with the date or day of the week in on the first tab, when I pick a day such as Monday it populates the table with all of the data for that day which then in turn populates the sheets. Then when I pick Tuesday in this cell it changes all of the data in the table to Tuesdays information and so on for everyday of the week. This data that is being used would come from a master table on a hidden tab so I would only need to update this weekly and the rest of the week I could just pick days.

Any help would be much appreciated.