Values of cells to be routed to other sheet

Dear All,

Please refer the attached excel Sheet1 Columns F & G

Location is a dropdownlist where I've made search suggestion with formulas

Dispatch Type is another dropdownlist with only 2 values

Model is a custom data validation formula which minimizes the values of F14 to F48 i.e., If I type 600 in G10, it will display values of only those values which contains 600 from F14 to F48

Requirement of Quantity button:

1. When I select location, Dispatch Type & particular cells in F14 to F48, Enter quantity in G14 to G48 (based on the values minimized in F14 to F48), Those quantities or values to be routed to SSR Sheet to the particular cells

2. Message box has to be displayed with models that I selected and total quantity of those models after summing up the values

3. if you have any thoughts with better improvements, Please do & let me know. But not manditory

Request you to please help on the above requirement and do the needful.