Creating a Macro

Hello,

I am trying to create a macro that takes information from 6 separate sheets and pools them into one excel document. Essentially it would take the data from O3 through T3 in one sheet, I select the number to multiply by, and it would populate in one excel document for me. It would then go to O4 through T4 and continue on through O67 to T67. Then it would move onto the remaining 5 sheets and do the exact thing for those. The final product would have one document with the final numbers in a sheet.