Multi-Sheet Question

[scubab]

Hi there again,
I'm working on yet another project here at work and I could use some more help. At my work when a customers device has returned from repair we will send them a post card, another post card and call them. I've decided to see if I could make this digital.

What we do is, once the device has returned, we send a post card. Five days later we send another post card, five days later we call them and then five days later we bill them if they had a loaner unit and haven't returned it yet. I've got 31 tabs for each day of the month (the one attatched only has 7).
Let's say we send the postcard today (11/9) we would send the second postcard five days later, 11/14. Would there be a possibility to have a link or something auto generated on the 14th (for example) so it will take me to the sheet from the 9th, or at least alert me, so I know I need to send the second postcard and also anything else that needs to be done on the 14th, such as call or bill?

So, essentially, I want to click on the tab for the current date to send the first set of postcards, but I also want to be alerted that this is the date to send the second card from <5 days earlier>, calll from <10 days earlier>, or bill from <15 days earlier>

Thanks a lot!!!

[Excelenator]

Why is it neccessary to have a tab for each day? Wouldn't it be easier to normalize the data into ONE database and then you could have columns that would generate the dates that postcards, phone calls, and billings should occur. Then you could simply filter the database for the current date on all three columns and see which customers should get post cards today, which should get phone calls, and which should be billed all at the touch of a button!

[scubab]

Using a database would be awesome, but this has to be something accessible to our sales staff who are all familiar with Excel but not Access.