Hi -
This appears to be a very simple process - but not matter what I do I cannot
get it work.

I have Sheet 1 through Sheet 4 of a workbook
Sheet 1 contains all values
Sheet 2-3 contain subsets of the values from Sheet 1
I would like for Sheet 2 and Sheet 3 to automatically update when the values
are updated in Sheet 1
All cells contain text only, not formulas
I have tried every combination possible and I cannot get the values in
Sheet2 - Sheet 3 to update automatically
Here is an example - In Sheet 3, Cell D3 I want to reference the value from
Sheet 1 Cell D46
I go to Sheet 3, Cell D3 and enter
Sheet1!D46 - does not work
Sheet1!D$46$ - does not work
= in front of the previous 2 references does not work
CELL(Sheet1!D46)
CELL(Sheet!D$46$)
I've used INDIRECT and countless other samples and no matter what I try -
all i can see in the Cell is the reference that I just typed in.
I know it's very easy and I'm missing some simple step - but I can't see it.
Thank you in advance for your assistance.

Regards,

--
crisg