Excel – Combining Worksheets to View on One Master Sheet

Good Morning!

I have multiple business plans for planting of 10 different crops, on 10 different worksheets.

The image image URL attached shows one business plan.

The first section (from the left side moving to the right) is a layout of “labor hours” through each week of the year. Right of that are 2 totalling sections, with many formula’s going on, totalling different aspects of the plan and giving me bottom line info on the far right.

I’m trying to figure out how to show all 10 business plans on one master worksheet, so I can print it and show them stacked visually on top of each other for meeting purposes.

Can anyone tell me how I can do this?

If I copy and paste, the formulas get messed up, and there are too many for me to rewrite them all on the master sheet.

Because the totalling sections are there, I can’t use “Power Query” to do it, as far as I can tell.

Any thoughts?

Thanks very much!

-Mike

 

 

 

 

By: MasSaSeen Francis

Leave a Reply

Your email address will not be published. Required fields are marked *