macro to amalgamate 2 worksheets

[hungledink]

Hello,

I have a workbook with sheets for each day of the week, and a summary sheet. (Excel 2003)

In the weekday sheets, column A is a list of names, column B is a list of amounts. Each weekday sheet doesnt have the same number of names and some names may be missing from one day to the next.

I would like to be able to run a macro which will populate the summary sheet by looking at the names in every weekday sheet, and then transferring the names and the amalgamated totals.

Can anyone help?

Thanks in advance.