Can I make a sheet that displays data from other sheets?

[CW]

Hello,

Say I have an Excel workbook with 3 sheets (sheet1, sheet2, sheet3).

Each sheet has two columns (Date, Thing that happened on that date).

I would like to know if there's a way to have a fourth sheet, called
"on this date in history" (or whatever). It would consider today's
date (either from today() or from a cell that contains the date in the
excel date serial number format), and display each thing that happened
on that date in previous years on each row.

So basically, if I open the workbook on May 4th, 2007 and go to the
fourth sheet, it would show me a list list of events that happened on
May 4th in previous years. It would update each day I view it. Then
when I add rows to sheets 1, 2, and 3, it would update on the fourth
sheet.

Furthermore, it would be awesome if there could be a third column on
the "on this date in history sheet" that displays which sheet the data
was taken from.

Any help on this would be greatly appreciated! Thank you.

 

[mansoorm]

Yes, You can write an Auto_Open macro for your workbook that updates
4th sheet using the data in other sheets
It just looks for today in date column and copies data to 4th sheet
You must be familiar with macro development; of course !

 

[CW]

Yes, You can write an Auto_Open macro for your workbook that updates
4th sheet using the data in other sheets
It just looks for today in date column and copies data to 4th sheet
You must be familiar with macro development; of course !

OK! I know how to make macros, but I'm not sure of the exact code that
would make this work. I have very basic knowledge of VB and scripting,
so something like this is a bit advanced for me.