copying multiple tabs

[ronhc213]

I have created a spreadsheet to help me manage my monthly bills that will use data from the previous month. I have labled the tabs as "month-year" and have made enough tabs for the next year. My problem is that it is extreamly time consuming to manually update each block to reference the previous month's data. For example; the current month's begining balance is always taken from the last month's ending balance for each account. Is there some easier way to copy 12 tabs at a time and paste the formulas into new tabs without having to then to go back and update individual formulas in each tab?

 

[MaddMike]

If you hold the CTL key down while left clicking the mouse on each tab/worksheet you want to copy, then right clicking after you have chosen you can then copy to another workbook or make copies in the same workbook of the Tabs you have chosen.

 

[ronhc213]

Thank you! That worked perfectly.