Link Through Summary Sheets

Hi Guys,

I'm a trainee accountant and a trainee macro writer so any help would be great thanks!

I have several worksheets which contain rows of data and each row has a unique code (a cost centre code). These cost centre codes do not appear within every worksheet but can appear in one or all of them.

I also have a summary sheet which contains all of the cost centre codes that appear on the other worksheets.

I need to write a macro that will lookup the appropriate cost centre code on the summary sheet and then look for the same code on the other worksheets and if it finds it then adds the values together into the summary sheet.

Each of the rows has several columns and each of the columns needs to have this summing done.

It would also be useful if this could be done to automatically update if the worksheets are updated.

I know that none of this should be too hard but I'm just a bit stuck as to how to get started!

Many thanks for your help,
Jo