all sheets need the same
 

In advance thanks to everybody who is helping me out... I am quite an amateur
in Excel ;)

I am working on an Excel document, to which different users have access. The
document also contains many links (via the INDEX formula).

Some basic information (which indicates a certain product) needs to come
back in every sheet.

So if I have 4 sheets, lets say:
- general information
- prices
- marketing
- distribution

Then every sheet should start with the same columns (lets say: unique
identification number, registration name etc.).

Two questions:

1) is it possible that if someone in sheet 'general information' clicks on a
unique number, that that number then automatically highlights in the other
sheets? Or is there some other way that people do not need to scoll and
search to get to a certain product in a certain sheet (I do know about the
search option with control F, but I am looking for something even more
sophisticated, and more user friendly).

2) Then, if one needs to delete or add a specific product, it would be nice
if this should only be entered once. So that people not need to fill in a new
unique identification number, registration name etc. in the 4 different
sheets.

I hope someone knows something about how to present the sheets nicely, and
user friendly!

Thanks a lot in advance.

Marieke