Thread: Excel - moving cells from one sheet to another?

Hi,
I was wondering if any of you know how to do this in excel

What I want to do is put my assignments, appointments, meetings etc. on one sheet then put the stuff for one week (today + 6 days) on another sheet.

That way on the one sheet I can see everything, and other sheet I can see just what I have to do the next week without entering everything manually.

I'm pretty sure this can be done using conditional formatting or some kind of filter, but I can't figure it out...

Thanks!