Multiple subroutines created in the attached file. I placed two buttons on the Summary sheet. The "Check Sel Exists" button is used to Check if the selected combination exists in the summary sheet. If it doesn't exists, then a new table is created in the summary page and the data is entered into Fourth tab. The 'populate summary' button populates the summary sheet pulling data from all the other sheets. Furthermore, any change to column E in the other sheets will fully update the summary sheet. The data validtion cells are populated through code with all the values that exist in the data.
Place these subroutines in a module
Place this subroutine in each other(not summary sheet) sheet module:
Bookmarks