I'm sure that this can be done, but the way you've set up your file is going to make it really really akward. To be honest, it probably makes most sense to build up all the shipment information in a pivot table and then try to extract the relevant pieces to each report using GETPIVOTDATA formulas. But it's going to take a much better understanding of your data and re-write of your entire workbook to make that happen...