Get Data from Other Sheets, Pls Help!

[leo_821]

I have a workbook with several different sheets. In one of the sheets (eg Sheet 1) I need to get data from the other sheets.
In this sheet 1 from where I want to get data, I have a column for all the days of the year (format example: 22 September 2011). On the other sheets I have a column with the date of every month.
I want a macro to search on every sheet a value of a balance - if the date from Sheet 1 matches the date of the other sheets, that is when the date matches, go down 48 rows to get that value and paste it on Sheet 1.

I am new to VB. I would appreciate if someone could help me out

Thanks