I have attached my work book.
I would like help with my macro so the tabs date automatically when sheet 2 cell B5 has a date entered. At the moment I have to click on a cell in each sheet before the tab dates change/show
On sheet 2 there is a table of dates.
I would like sheet 3 tab to show the date from cell B5 from sheet 2
I would like sheet 4 tab to show the date from cell B6 from sheet 2
I would like sheet 5 tab to show the date from cell B7 from sheet 2
I would like sheet 6 tab to show the date from cell B8 from sheet 2
Many Thanks
