Excel Filtering for a Summary Tab

[ItalianPlatinum]

I have a 5k+ row sheet that contains Invoices, job Ids, Merchants, with Due Dates and Shipment dates among a lot of other unique data. I need a way to quickly and easily identify based off of year when something was shipped. I want to maintain one sheet lets call it data. Then be able to look at another sheet say (2024) or (2025) to reference right there automatically what has been shipped for that year. The sheet 2024 will have all the columns in the data tab that I populated. So essentially a summary filtered by Ship date of 2024. Would anyone be able to help? The user isn't very computer inclined so having them filter or advance filtering themselves is a no can do. I know Excel has FILTER and UNIQUE filter formulas that I think may work but I had issues getting them to work so looking for some help. Thank you in adcance!

Job #	Shipment Date	Due Date	A	B	C	D	X	X	X	X
1	1/1/2023	12/2/2022	AA	12	123	1234	X	X	X	X
2	1/1/2022	12/2/2021	BB	66	55	77	X	X	X	X
3	1/1/2024	12/2/2023	CC	99	88	24	X	X	X	X
4	10/1/2024	9/1/2024	DD	856	874	314	X	X	X	X
5	10/5/2020	9/5/2020	EE	101	202	303	X	X	X	X
6	9/9/2020	8/10/2020	FF	444	555	666	X	X	X	X
7	9/1/2024	8/2/2024	GG	888	999	110	X	X	X	X
8	11/1/2024	10/2/2024	HH	5687	45874	2365	X	X	X	X

 

[ItalianPlatinum]

Interesting that is kind of neat. Both work well.