Copy data from multiple worksheets to a masterfile worksheet's specific sheet name

Hi Excel Experts,

I need a help with my excel files, the scenario is, I have 1 master file named (masterfile) and 11 worksheets this is for the daily service of our technical support, each of them should input the details of their service to their excel files, and each technical support has it own worksheet named (SA_2014_ACM.xls, SA_2014_ASE.xls, and etc.) to use. Right now the only thing i can do is to monitor the pending tickets, resolved tickets and technical support specialist that is available using the masterfile. What I want to achieve is the data from each worksheets of technical support should automatically appear on my masterfile and to sheet named(HSCF). I also attached some sample files for reference.

Please help me with this one.

Thank you and Best Regards.