VBA to create Summary Sheet

[Manchesterisred]

HI All,

I am looking for a VBA to create a Summary Sheet table.

It needs a header in cell A1 called "Mandate", header in B1 called "Company Name," , header in C1, called " Amount in DC", header in cell D1, call " total on summary" and header in cell E1 called variance

Then in cell A3, I need it copy from each worksheet, cell E21 to go under mandate, cell B22 to go under company name, Sum up column G and divide by 2 to go under Amount in DC, a sum if to go under total on summary and then total on summary minus amount in DC to go under variance.
This should loop through all sheet s and create a table.

Can anyone help me write this ?

thank you

 

[DanteAmor]

Sum up column G and divide by 2 to go under Amount in DC, a sum if to go under total on summary and then total on summary minus amount in DC to go under variance.

I did not understand well.
You could give an example of one of your sheets. Show what you have on that sheet and what are the results you want in cells C3, D3 and E3 of the summary sheet.

Use XL2BB tool minisheet to give an example.