It sounds like you could use =vlookup().
You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
Alec H wrote:

Hi,
I am creating a customer database in a Excel 2000 pro workbook. It
comprises
of multiple worksheets each containing a different companies details
(branc
hes, phone numbers, etc). I have ensured that in all sheets column A is
a nu
meric field and that each row has a unique number in this column
(unique acr
oss all sheets).
Where I have got "stuck" is that I want to create a additional
worksheet in
which I can manually designate a number in a cell (column A) and excel
will automatical
ly fill the remaining cells in that row from whichever sheet the number
corr
esponds.
Help please.....
--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=507154
--
Dave Peterson