I need a macro that can copy a cell a2 then paste into a cell on another sheet to update a report then run a series of process to email the report, I have the email section, then select the next cell down from the original, a3, and paste it into the same cell on the report and continue copying the next cell down and repeating until it gets to the bottom of the list.

I currently have a report with a lot of tabs for the same report with the numbers manually keyed in. Having this would allow me to delete the tabs and rely only on the macro. Please help.