Hello. I am trying to consolidate several worksheets into one that will update dynamically on the occasion of an update to one of the individual worksheets. The worksheets are all in one workbook. I have a multiple column / row spreadsheets that contain inventory information therefore none of the data needs any calculating... the data just needs to be consolidated into one master list. I have tried the tip above using the =sheet!1A3:L72 and got no result... any suggestions would be greatly appreciated!