Referencing a list throughout multiple sheets that automatically updates

[HalKinsey]

I am working on a project as a contractor, and I am having a somewhat interesting problem. The company sells chemical products and I was instructed to have one page where the products are listed and can be updated throughout the document. I was also instructed to use type selective drop-down boxes (I used combo boxes) for each day, for an entire monthly report. My current issue is having to manually update 300 combo boxes of the products list because I don't know of any way to have them update automatically when the 'Products List' page has been updated. Any ideas?

 

[HalKinsey]

Unfortunately, I don't know how to describe it any better. I don't know enough of the terminology to ask my question in a helpful way

 

[Stridhan]

upload a samplesheet