Macro to annualise a quarterly financial model

[Rubix cube]

Hi,
I have an Okay knowledge of excel but have never used macros before.
The workbook I am using currently has a lot of quarterly input data that I need to convert to annual figures. I have updated the formulas throughout for the calculations and outputs across a number of tabs but am hoping to save some time with the inputs by running a macro that can annualise the quarterly numbers.

Is there a way using macros that I would be able to convert different quarterly figures ($, % & #) into an annual amount based on either weighted averages or their respective sums?

happy to give any other info.
Thanks

 

[=ODIN=]

Sure, but your question is too general for anyone to tell you how.
One can tell a macro to take a number/row/sheet/sepecific-data-set and multiply itself by 4 (or whatever...), but one cannot tell a sheet to annualize itself.