Just some thoughts. Think what you're after here could be done using either
VLOOKUP or INDEX/MATCH provided there's unique values in a key* col which is
common to both sheets, eg: Product ids?
*which could be used in matching

Suggest you browse Debra's nice coverage on VLOOKUP or INDEX/MATCH at her:

http://www.contextures.com/xlFunctions02.html
VLOOKUP

http://www.contextures.com/xlFunctions03.html
INDEX/MATCH

There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mex" wrote:
How can I link two pages in the same book so that each time a cell is updated
the info carries to the other sheet AND I be able sort each sheet differently
and not lose info?