Lock source data on multiple worksheets

[scottranzal]

Trying to accomplish the following:

1 Workbook
Multiple Woksheets
1st worksheet has 4-5 columns of non unique data (many rows)
2nd-nth has many columns and rows

I would like to be able to display these 4-5 columns of data on every other worksheet within the workbook - LOCKED, so no user can adjust it. The only sheet that would be able to update the 4-5 columns of original data is the 1st. I then need to pass these adjustments to the other worksheets, so that each page is in sync.

Wanted to use Pivot table, but....

I need to add data to the rows in additional columns, so a Pivot table update would wipe that out.

Here's an example of the first sheet (source data)

Column
A - B - C - D - E
0 1 3 5 14
Q W E R T

the additional sheets must have that data plus...

Column
A - B - C - D - E - F - G - H
0 1 3 5 14 Q R 0
Q W E R T A B 5

Can't figure out a way to achieve this, so help would be very much appreciated. I've thought about filters, pivots, macros but no one solution has come to mind.

thanks

scott