Update master list with other lists
 

Hi,


I've posted this one here before without getting any further. Please read
through the problem and grace me with an easy to understand explanation if
there is one, and if not please write anyways :)

In a single workbook I have around about 20 sheets. Sheet 1 contains a
"master list". In column A, I have a list of text entries. Each consecutive
sheet also have a list in column A, which contains 100 entries. These entries
will change for each consecutive sheet in the following fashion:
- an entry may have been removed
- new entries may have been added
- and entry may be in the same or a different position in the list

I have an excellent formula in the master list which checks if an entry in
the master list is present in each of the consecutive sheets or not. The
formula in column B checks sheet 2, column C sheet 3 etc. Still, I need to
have the master list itself update so I don't have to go through each new
sheet as it is added to make sure I have all entries also entered in the
master list. So, the master list should really be filled with formulas or use
a VB macro which lists all entries in all other sheets, but obviously should
every entry only be displayed in one cell, i.e. no duplicates.

Please let me know if further explaining is needed, I'm quite dumbfounded by
this problem myself and do not even know if I can manage with an Excel
formula or if I need a Visual Basic or similar macro.

Help!:)

--
Chab