On each person's sheet use a formula that looks for their name on the
Master Inventory sheet, and offsets from that cell:

=OFFSET('Master Inventory'!$A$1,
MATCH($A$6,'Master Inventory'!$A$1:$A$200,0)-1,36)

wrote:
I have a main sheet and many additional sheets with peoples
names' (each sheet is named for a person - including a command and
space). The main sheet is named 'Master Inventory'

On the main sheet, there is a row for each person. Column A has the
names of all the named sheets.

Each person named sheet has a cell, A6, with it's sheet name.

I would like a specific cell in each named sheet to reference the cell
in 'Master Inventory'!<row with the name in cell A6, <column AK

example:

Master Inventory cell A12 has the name 'Smith, Joe'. I would like a
cell in sheet 'Smith, Joe' to be the contents of master inventory cell
AK12. I would like to use the same formula on each sheet.

How can I do this?

Thanks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html