Excel indirect reference to normal reference

JKPieterse 

Thank you for reply.

Yes, all the files are in one folder.

Since I have all my employee ID and as the employee ID will not be continuous. I have listed it in a separate workbook in "Sheet1's" A column and with indirect reference like shown below for "Date of birth"

=indirect("'["&$a2&"]personal_details'!$B$6",1)

Similarly for the "Date of joining"

Is there any other way with direct referencing so that I will not having the problem to open all the 200 employee files at the same time.

While replying this I got a idea that can we concate this to a text and make it workable.

Let me try this and reply you.

Thanks in advance.

With regards,

Sivaprakash