One Workbook... with one generic Item Dataset. Turning into a Pivot Table with Rows of Item Name. Columns of Location (with 5 locations). and Measures of Quantity on Hand. End result for 30k items = Pivot table building aborted - data limit exceed. Really? That's nothing...