Pivots or VLookups or both

[khristinaLores0909]

I have a file from a client.  They have asked me to see if I can automate pulling data for two different plants, and in each plant I need numbers for two different types of products... and I need the report to show one day at a time, updated daily and only 7 days (or more) in the future.  

I have an excel file that they are manually putting data into, but I dont even know if this is the best way to present the data. I have been reaching out to friends and family.. trying to bribe who ever I can to see if they can help, and so far, its beyond what anyone that I can reach knows how to do.  I have been trying to watch videos but nothing seems to be giving me the information that I want.  

Do I use Pivot tables? Do I do Vlookups? Can I use both?  How do I do this with so much filtered information.  

Below is the report they are asking me to fill.  (not sure how to get a better shot in this post).

I have the base data too.

Is there someone to help me? 

	MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY
TORFLEX	SPRUNG	TORFLEX	SPRUNG	TORFLEX	SPRUNG	TORFLEX	SPRUNG	TORFLEX	SPRUNG
4/4/2022	4/5/2022	4/6/2022	4/7/2022	4/8/2022
WEEK 4-8	61 60							63	281	161	250
						118	276	345	88
	TOTAL							T= 181	S= 557	T= 506	S= 338
	4/11/2022	4/12/2022	4/13/2022	4/14/2022	4/15/2022
WEEK 11-15	61 60	63	139	10	490	509	114	176	550	436	218
822	580	139	178	504	187	471	189	72	33
	TOTAL	T= 885	S= 719	T= 149	S= 668	T=1013	S= 301	T= 647	S= 739	T= 508	S= 251
	4/18/2022	4/19/2022	4/20/2022	4/21/2022	4/22/2022
WEEK 18-22	61 60	171	455	34	191	500	15	58	413	58	333
450	291	533	296	33	16	461	228	0	0
	TOTAL	T= 621	S= 746	T=567	S= 487	T= 533	S= 31	T= 519	S= 641	T= 58	S= 333
	4/25/2022	4/26/2022	4/27/2022	4/28/2022	4/29/2022
WEEK 25-29	61 61	789	127	988	401	204	17	850	43	6	333
1023	37	1264	506	210	18	1091	142	17	666
	TOTAL	T= 622	S= 747	T=568	S= 488	T= 534	S= 32	T= 520	S= 642	T= 59	S= 334