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

[lenovo03]

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.

[Richard Buttrey]

Hi,

Although you're referring to 'Workbook sharing' functionality which Excel has, most of us advise against using it since it causes far too many problems. But in your case since I'm assuming that your technical support team are roving around and not able to share a central workbook it's not appropriate anyway.

You could create macros to consolidate many individual Excel files into you master but you might also like to consider Google Docs. You can create a form which is linked to your master sheet and distribute the form to your technicians. As they complete their forms, using mobile devices if necessary, the form details then update the master workbook automatically.

Check out the link here:

https://support.google.com/docs/answer/87809?hl=en

[lenovo03]

Ok sir, i'll try this hope this can help me.
Thanks a lot.