hello,


I need to create this report but I need your help


I uploaded sample file here :
https://app.box.com/s/p9uv3mbhwoop2wobrfky3v3fvwj6ci27


So I have main chart in Sheet1 and I will be inputting weekly data in each tab.


Weekly data includes different kinds of datas.


But I need
-Only certain employees. Sheet1 has a list of employee numbers. I need a format that searches the employees numbers in Sheet1 and their data.
-I only need certain data.


So for example, in the sample file,
I need to pull


-Data 4,7,10,13,18 and 27


on


Employee numbers 48511, 49324, 43610, 49612, 36473, 43434 and 49446.

I need a format that generates the data automatically when I copy and paste the weekly data in each tab.


I greatly appreciate your help.