I apologize for the very delayed response. And I truly appreciate all the time and effort you put into creating an example based on our data.
We were hoping to make the view for the end user very very basic excel worksheet looking and no formulas that could be deleted. We know we can go through and lock down cells for the formulas but we thought it would be better for all involved to use VBA to build our project.
We did get further with VBA between my first post and your response with the example you created. I am attaching a copy. But there are issue with the button and as we reviewed the project with the people needing it there were more requests.
We are looking closely at what you provided and seeing how we might go in that direction instead of what we currently have.
The data in the attached is true data. There are no duplicates per dates and PO numbers.
What we are looking for is a way the end user can see all the "DailyList" worksheet, but use the "SummaryOrderTracking" worksheet to update to the "DailyList" with List date, PO number and Status.

Attached Files

vending list test excel_Upload_Macro_7_RealData3ol.xlsm (77.9 KB, 2 views)