Select Sheets For Specific Date By Clicking On A Calendar

[peter renton]

Hi All

I have attached a booking sheet to this post.

This will be used to pre book vehicles in for mot, at the moment there is only a couple of sheets as a test but when it goes live there will be a sheet from monday and wednsday every week for at least one year but maybe more.

I have indexed the pages with hyperlinks but this will get messy as the sheets grow,
My question is:-

If i name the sheet tabs with a date and year can an embedded calender be used to select a tab i.e. if i open the calender and select 5th may 2013 it will open the 5th of may 2013 sheet??

Thanks for any imput

Peter