Template Sheet that (when edited) updates ALL sheets

Hello,

I need to create a log that tracks a large number of companies (sheets) and their added expenses. Any formatting changes (new column, new row, new heading, etc.) I make to one sheet (company) must be applied to ALL sheets. Instead of highlighting the change and using Fill -> Across Worksheets every time there is a format change, I want to create a TemplateSheet that I can use to manipulate all sheets. This TemplateSheet will not contain any numerical values, but will contain formulas and the formatting (column names, rows, headings, images, etc.) that I want every sheet to have. The numerical values will later be manually inputted into each individual company's sheet.

Template for Updating Sheets.xlsx The first sheet in this workbook is the TemplateSheet that I want to continuously update. It only contains formatting and formulas. Sheet1 is an example of what might need to happen in the future. At some point I may add a column or row. Again, all sheets need to reflect this change... The rest of the sheets are blank placeholders.

This may involve macros that are outside of my level of understanding. Maybe not.

I'd like the changes I make in TemplateSheet to spread to all sheets automatically. What do y'all think the best way to approach this is?

Create a cell reference to another worksheet
You can refer to cells that are on other worksheets in the same workbook by prepending the name of the worksheet followed by an exclamation point (!) to the start of the cell reference. In the following example, the worksheet function named AVERAGE calculates the average value for the range B1:B10 on the worksheet named Marketing in the same workbook.

Sheet reference example
1. Refers to the worksheet named Marketing

2. Refers to the range of cells between B1 and B10, inclusively

3. Separates the worksheet reference from the cell range reference

Click the cell in which you want to enter the formula.

In the formula bar Button image, type = (equal sign) and the formula you want to use.

Click the tab for the worksheet to be referenced.

Select the cell or range of cells to be referenced.

Note: If the name of the other worksheet contains nonalphabetical characters, you must enclose the name (or the path) within single quotation marks (').

https://support.microsoft.com/en-us/...e-c835903cebaa