I have a spreadsheet with specific sets of cells that I would like to be able to just tick a checkbox (or something similar) which ones I need to make a one full set on a main sheet.
Example (width/amount of cells in a row is fixed to 6 at all times):
- Sheet 1 has 6x7 cells
- Sheet 2 has 6x3 cells
- Sheet 3 has 6x12 cells
- Sheet 4 has 6x9 cells
On main sheet I would like to just select #1, #3, and #4 and it would make a nice set of 6x28 cells. Formatting needs to be kept since different sheets have different colours