programming the camera tool ?

hello all,
im new to the forum and quite new to excel (you're going to have to dumb down your responses, sorry)

im working on a group project for uni right now which is designed to get us to explore excel and learn additional features, then implement them in a spreadsheet that will help us with through the next three years.

i would like the cover sheet to display a weekly planner which is on a separate sheet. this schedule has a unique list of events, class times, and assignment due dates, for each of the 13 weeks of class. i need the cover sheet to display the relevant week based off of the "=TODAY()". Due to the different formatting (it was made by a different group member) it seemed the easiest way to display it on the cover sheet would be to create a "window" to the other sheet. The camera tool seems like a good option.

My problem is i don't know how to make the selection of cells that the camera displays move according to the date.
is there a way to create a MACRO that would change the selection every seven day?

if there is a better option please let me know. thanks for your time.

ryan,

i apologize if i have posted this in the wrong location.