How to use macro to summarys an excel sheet

[Dway]

Good day friends, am a first timer.
need your help, i use a peachtree software in my office and on the software i can export to excel. but i have a problem with the excel sheet cos the number of cell i get are very much so am looking for a way i can alter the macro in excel to create a summary sheet for me where all the number of cell are reduce.
attached to this is a sample of what i want.

summary of the excel.
basicly looking at the income stmt sheet from cell A:E is what comes out of the software now on cell H, i use an excel formula to calculate what i want and cell I reflect what the calculation represent.
when you click on cell H you will see how i arrive at does figure.

now going to the first sheet named P&I thats the summary of what i want and the summary is gotten from the calculation of H and i.

so what i want is how to code a macro that at a click of a butten i get the summary with out having to go thrught the process of the calculation.

please am not good at programming so i will love if some one could just help me out and expline all to me.

[royUK]

Can't you export the correct style reports?

You could set up a template with all the reports with formulas then simply export your data & copy & paste it into the data sheet of the template.

[Dway]

thanks royUK that i can do and if u take a close look at the excel sheet i sent u will notice thats what have been doing but its static cos i have to start creating a sheet for it every time or better still copy and paste every time.
but what i want is some time dymanic i dont have to open a sheet or copy paste every time ,with a click of a command button i want it to generate it.
have read about it but i think the best way is to like it up to a vb program since excel is written in vb but i dont no hw to code.