Multiple excel sheets with same headings
 

I have 14 sheets with me for 14 different users. Now I want the data to
come out of it for each person. The sheets are titled by the names of
the individuals.

Can MS Query be used for this? If yes, how?

If not, then what shall I do?


--
mohitmahajan
------------------------------------------------------------------------
mohitmahajan's Profile: http://www.excelforum.com/member.php...fo&userid=8130
View this thread: http://www.excelforum.com/showthread...hreadid=470132