Macro to multiple two columns then sum?

Hi everyone,

Here's my problem. I have a work book with 97 sheets, all of the sheets are identical in format but contain different data. I need to multiple column F (which is a price) by column G (which is a quantity). I then need to sum the results and spit this number out on a new sheet. So in then end I would have 97 entries on the new sheet with this new sum which would give me are total stock value on hand.
I've been trying to do this by recording Macros but have had no luck.

Can anyone help with a macro?


Thanks for any help.

Nick