I am trying to create an auto populated master tab from multiple other tabs (there will be 10 total) All my Macro or Combining efforts have failed. I have a tab that will be hidden that is populating dropdowns and workday formulas. The 10 regional tabs will be updated and change based on new rows being added and i would like the master to be able to accommodate that. Thanks!

Merge test for master tab.xlsx