Help with creating a macro to anaylse and pull data from multiple worksheets

Hi,

I have attached a sample spreadsheet to assist with my problem.

I am needing to run a macro to look through the 3 worksheets and list any accounts that do not total 100% (cell D35) into the summary tab. Ideally this would then list the code of the account (cell C5), the name of the account (cell C3) and the total percentage (cell D35) into the Summary tab.

Any help would be much apprecitaed!

Eoghan