Macro help

[wakaka923]

Hi,

My team pulls open orders weekly and puts them into a workbook. This workbook has all the columns/data I need but I want it in a specific format and it is also always put in the same place with generally the same name. I need to pull into separate workbooks the sum of units by the due date (horizontally) and by certain style numbers for certain suppliers. For example Exhibit A is the data set pulled by the team every week and Exhibit B is the format I'd like it to be in.

I'd like this to be done automatically.

Exhibit A:

Collection	Style#	Due Date	Order Qty	Supplier#
Sweaters	12345	1/20/23	2	100001
Dresses	67891	1/27/23	4	200002
Sweaters	11121	2/3/23	6	300003
Sweaters	12345	1/27/23	2	100001

Exhibit B:

Collection	Supplier#	Style#	1/20/23	1/27/23	2/3/23
Sweaters	100001	12345	2	2	0
Sweaters	300003	11121	0	0	6
Dresses	200002	67891	0	4	0