Totalling amounts from drop-down lists on mulitple worksheets

[GeoTX]

Hi all - I have seperate tab worksheets for each project in my year and am making a budget cover page, where I would like it to total the amounts posted to each of the codes in the drop down lists on the other sheets.  How do I do this please?

Thanks in advance!

[#2]

I am not clear what you describe.
If you share a file with data and show your expected result,it will be intuitive to get the problem.