Macro to add multiple identical rows of data from a workbook before or after each change in Column A

[rickadams]

I can insert blank rows between the data when value changes. I am asking how to add the same 7 rows of common data (as in a checklist) to the top or bottom of every sheet and also add the data from the A column after the change to the 7 rows. I can add them to the top of the list with the rows to repeat at the top $1:$7 however this method does not include the data from Column A. I would prefer to add the 7 rows to the top or bottom and add the data from the current A Column before the data changes. Thank you for your help.

BEFORE

LOCATION

TASK OR ITEM REPAIRS REQUIRED

CATEGORY

NOTES - MATERIAL STATUS

ASSIGNED TO

STATUS OR TASK IS IT COMPLETE?

	REPLACE THE SMOKE DETECTOR BATTERIES IF THEY ARE REPLACEABLE	BATTERY	N/A TO 10 YEAR SYSTEMS	RICK
	REPLACE THE DOOR LOCK BATTERIES	BATTERY		RICK
	TIGHTEN ALL CABINET DOOR HINGES	GENERAL		TOM
	CHANGE THERMOSTAT BATTERIES	BATTERY	N/A TO 10 YEAR SYSTEMS	BILL
	CHANGE AIR FILTERS AS REQUIRED	FILTERS		JOE
	PLEASE BE SURE A/C IS OFF WHEN LEAVING AT THE END OF THE DAY	EVERYONE	CHECK DAILY IF NOT OCCUPIED	EVERYONE

121 MAIN STREET	BED 5 - PAINT ALL	PAINT		JOE	COMPLETE
121 MAIN STREET	LR- PAINT 3 WALLS	PAINT		JOE	COMPLETE
121 MAIN STREET	BED 4 REPAIR LOCK	LOCK	PLUNGER WAS BAD, REPLACED 06/04/24	JOHN	COMPLETE

The data in Column A (location) could be listed 1 time or 50 times until the next address and the blank on the 7 lines at $1:$7 are always the same to be added to the list.
A could have:

Sheet would look like this when VBA is finished

LOCATION	TASK OR ITEM REPAIRS REQUIRED	CATEGORY	NOTES - MATERIAL STATUS	ASSIGNED TO	STATUS OR TASK ITEM COMPLETE
121 MAIN STREET	REPLACE THE SMOKE DETECTOR BATTERIES IF THEY ARE REPLACEABLE	BATTERY	N/A TO 10 YEAR SYSTEMS	RICK
121 MAIN STREET	REPLACE THE DOOR LOCK BATTERIES	BATTERY		RICK
121 MAIN STREET	TIGHTEN ALL CABINET DOOR HINGES	GENERAL		TOM
121 MAIN STREET	CHANGE THERMOSTAT BATTERIES	BATTERY	N/A TO 10 YEAR SYSTEMS	BILL
121 MAIN STREET	CHANGE AIR FILTERS AS REQUIRED	FILTERS		JOE
121 MAIN STREET	PLEASE BE SURE A/C IS OFF WHEN LEAVING AT THE END OF THE DAY	EVERYONE	CHECK DAILY IF NOT OCCUPIED	EVERYONE

121 MAIN STREET	BED 5 - PAINT ALL	PAINT		JOE	HOLD OFF LAST
121 MAIN STREET	LR- PAINT 3 WALLS	PAINT		JOE	HOLD OFF LAST
121 MAIN STREET	BED 4 REPAIR LOCK	LOCK	PLUNGER WAS BAD, REPLACED 06/04/23	JOHN	COMPLETE

Thank you for your help