Hi,

I am working on a Workbook database which will be referring to multiple other workbooks with multiple worksheets. Every workbook is a buyer, and every worksheet is an item, named after the item number. The one cell (A45) within the worksheet is the quantity which I want in the master workbook. My problem is, I want to have a list of all items possible in my master workbook, and retrieve the quantity cell from each worksheet, but not all workbooks have all items, leaving me with cells which would be refering to non-existant worksheets. I get the "#REF!" and its causing me a lot of grief. Can someone suggest a solution? Or even another easier way to do so.

Thanks in advance,

Nick