consolidate monthly worksheet data into correct month's column on master sheet

Hi.

At the end of each month a user will paste cable subscriber data into a sheet for that month. I have a Master sheet that needs to look at each month's sheet and bring in the subscriber data into the appropriate columns.

Also, the number of cable companies on the monthly sheets is not fixed, as occasionally new companies may be added to a sheet and be included going forward.

I have formulas in place that can pull out the data I need from each month's sheet but I can't figure out how to get it over to the master sheet.


I've attached a workbook that shows what I am trying to do. The examples are sheets "Master" and "Jan". Attachment 175781

Thanks!