My knowledge on formulas and writing macros is very limited. I am working on a Master Spreadsheet for a field crew and need some help. Here is my issue:
I have a workbook with multiple tabs (currently 8, could be up to 50). Each employee has his/her own tab where they make any notes/updates on their task. The master sheet is basically a summary which includes all info from all sheets. There is a unique ID number associated with each task, which is in column A of each sheet including the master. I need to be able to write a formula/macro for the master sheet that will search for the unique ID number across all the employees worksheets, then return info from specific columns from the employees sheets over to the master.

If I need to elaborate, let me know. Thanks in advance.