data entered into 1 workbook updates into another closed workbook

[bqheng]

Hi, I have 2 workbooks that users work with. 1 workbook is for data entry and another is a master workbook that collects data entered into the first workbook. For simplicity sake, i have made an example file that has the worksheets from both workbooks and how the data should be arranged. In the data tab, users key in the year in B1, and enters data as per example file. These data will go into the master workbook based on the year that the data is from. So in this example, the data will go into 2016 tab. How do i code it such that the following issues are addressed:

1) Master workbook remains closed but still gets updated
2) The correct tab in the master workbook is populated based on the year in the data workbook
3) Barcode assigned and Volume number applies to the chunk of report numbers beside it. A blank row signifies the start of a new volume number while barcode assigned remains the same
4) Data entered may not be in sequential number. How do i get it automatically sorted in the master workbook from smallest report number to the biggest?

Any help would be appreciated.

[bqheng]

Any help please?