Merging multiple closed worksheets into a master file

I need to merge sheet 1 on 14 closed excel workbooks that will be updated on a daily basis with new information. I tried using the RDB merge add-in, and it works pretty well. However, each sheet has the same column headers and the add-in brings the same header for each file. The add-in also brings in all of the empty spaces at the bottom of the sheet - which makes the sheet inconvenient to use.

I have a VBA module that I altered from this thread: http://www.excelforum.com/excel-prog...-new-post.html
I'm getting a "run time error 9, subscript out of range" and the code is not drawing the data into the master workbook. The debugger highlights the line "Set sourceData = sourceBook.Worksheets ("MASTER").

I will upload the master file and two examples. I hope that someone on here can give me some help with the macro. Thank you.MasterTrack1.xlsmAWhiteTracking.xlsBLoweryTracking.xls

Thank you! This is pulling correctly now. I just have one other question. I need to run this macro multiple times a week so I can have up to date information. Is there anyway to add a line into the macro so it doesn't copy lines that have already been merged into the master file? Or will I have to have a blank master file every time I run this? Please let me know if something like that is possible. I will mark this thread as solved in the once you get back to me. you have been extremely helpful already. Thank you.