I still can't see why you need individual tabs, you could use a PivotTable to get the data, or a statement template using formulas to populate based on the selected supplier. I would always avoid duplicating data in this way