Combining data with the same dates

[kc19]

I will try and explain the best I can. I have 6 worksheets in one workbook, what is the best option to combine the data on one excel worksheet by date.

I need it to combine data with the same dates. Sorted by buyer.

 

[igold]

Hi kc19, welcome to the MrExcel Forum,
I think you would be much better off if you had your data laid out in a different format. Such as shown below. I am not copying all your data just a couple of lines so you get the idea. After the data is laid out like this, you can then "slice & dice" the data any way you would like... I would flip flop the date and buyer columns from what I've shown, but that's just my preference.

Buyer	Date	PartDesc	Qty
85542855	6/16/2024	Pencil	450
85542855	7/3/2024	Pencil	450
85542857	6/13/2024	Top Cap	36
85542857	6/15/2024	Top Cap	36