Gathering particular data

I need help in gathering some particular data from sheet1.
I have a name in F10 and in the same way F15,F2…etc.,
Now I need the data of Total Assigned (K13), Handled time (AS 13) and the Queue name (All in one Printer Chat) which is (C11)for that particular name (Which is in F10) and the same way for the remaining names. I cannot unmerge the cells every time because I have to get this data from different excel sheets which may contain above 200 sheets in each excel. So I am looking for a macro. One more thing I have a problem here is while generating the tool you can find that, for the last name in (F40) the corresponding Total Assigned and Handled Time are in sheet 2. As of now I don’t have the sheet2 with me. So keeping that in mind can anyone help me with a macro? I need all this data in a separate sheet (Either I can create it or you can help me in creating a new sheet in the same excel with the help of macro.