Making columns of one sheet match a column of another, but also adjust rows

Hi all,

I have two sheets within a workbook that contain different information regarding a set number of sites. Sheet 1 contains information on the owners of a site and their personal information and sheet two has information regarding who works at the site.

For example:

Sheet 1

A	B	C	D
Site Number	Owner Name	Owner Telephone	Owner Address
1122	Paul P	(222)555-6666	123 Fake Street
1125	Gary M	(222)555-7777	123 Elm Street
1129	Mitt R	(222)555-8888	123 Didnt Win Street

Sheet 2

A	B	C
Site Number	Inspector Name	Inspector Telephone
1122	Moe S	(222)555-1111
1125	Maggie S	(222)555-2222
1129	Obama B	(222)555-3333

Cells A1:A55 in Sheet 1 contains the site number (unique number, no duplicates--each site has a unique identifier).

What I need to do is make sure Sheet 2 has this same info in column A --i.e the columns match, but also insert or delete the corresponding rows when ever I remove or add a site from and to Sheet 1

I have tried a couple of things here:

1. Using A1=INDEX(Sheet1!$A:$A,ROW()) in order to match the columns in both sheets, but this cause a problem when ever I insert or delete a row from Sheet 1.

When I use this method and insert a new row in sheet 1 it does create the corresponding number in column A in sheet two (by shifting the numbers down and inserting the proper number in the proper place), but it does not shift the corresponding cells for that row. In the example above, I insert a new site between 1122 and 1125 (labelled 1123), the correpsonding information for 1125 (Maggie S, (222) 555 -2222) doesn't shift down with 1125. Essentially her information is now the info for 1123, which is incorrect. I need that row to be blank so that I can fill it in with new information.

2. Grouping the sheets together, but I don't want the column information to match for other columns, just column A.