Excel Vlookup Problem.

[kashif.special2005]

I have 5 sheets with the name "Summary_1", "Summary_2", "Summary_3", "Summary_4", "Summary_5" with the columns emp_id and dates, like column emp_id and other columns with the headings 1/1/2017, 4/1/2017, 6/1/2017 (date format:- dd/mm/yyyy)


and I have another sheets with the name "Summary_All" and I have column emp_id and dates column from 1/1/2017 to 1/25/2017.


Now the task is I want to apply vlookup on each dates ( in the sheet "Summary_All") from the summary sheets "Summary_1", "Summary_2", "Summary_3", "Summary_4", "Summary_5", but the problem is I don't know the date I am looking for vlookup is exists in which sheets?


Please help me how can I achieve this task.


I hope I describe my problem in details.


Thanks
Kashif