I am trying to integrate a system whereby we will allocate a the next number
in a sequence to the next unique item added to ANY of 4 separate
spreadsheets. The individual spreadsheets will have a name and unique code
number - I would like to be able to use a master spreadsheet to then allocate
a sequential number according to when they were added to the individual
spreadsheets.

Is this possible?

Lynne Murray