Populate information sheet tabs from data in table on first tab

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.

It would help if you posted an example file, so we can see what data you have and what you would like to be transferred onto the other sheets - the FAQ describes how to.

It would be more compact if you just had one subsidiary sheet, and on that you could select the driver name using a drop-down as well as selecting the day (or date) using another drop-down.

Hope this helps.

Pete