How to link headers across multiple sheets in Excel

To put a header eg: Company name on many multiple sheets in a workbook, type the name in a cell on the first sheet. On subsequent sheets, place a cursor in an empty cell.

Enter = (equal sign) and then click on the name in the first sheet. Press Enter. Repeat on as sheets as required. In this way, if you need to change the name, you only do it once.

You can do the same for addresses, phone numbers etc.