Collate data

I need data related to the name in (F10).
Required data is
Queue Name: Which is in C11
Total Assigned : K13
Total Handled time : AS13
The same way for all the names.
Please help me with a macro to do the same thing for 20sheets minimum and I need to pull the data for all the names which are in range (F2:F40) in all the sheets and the corresponding data of Queue name, Total Assigned and Total handled time also.
There is a problem which I found is, for the last name in sheet1 (F40) the corresponding data is in sheet2. Like the same way it may be in other sheets also.
Please help me.
I need all the data in all the sheets in a single sheet. (Note: I cannot unmerge the columns)
Attaching the required file for testing.
====
I have a script which will copy only the required columns to another sheet.

Sub OneCell()
    Sheets("Sheet2").Range("A1:A56").Value = Sheets("Sheet1").Range("C1:C56").Value
    Sheets("Sheet2").Range("B1:B56").Value = Sheets("Sheet1").Range("F1:F56").Value
    Sheets("Sheet2").Range("C1:C56").Value = Sheets("Sheet1").Range("K1:K56").Value
    Sheets("Sheet2").Range("D1:D56").Value = Sheets("Sheet1").Range("AS1:AS56").Value
End Sub

Please help me from this place or at least suggest me something. Give me an idea or a workaround. As I said I need the data as
For a Name: The Queue name is (something), total assigned is (something) and the total handled time is (something) in a single row so that I can get the required output for all the sheets.
At the same time please also help me with copy data in the same way from remaining sheets to the same sheet. (I mean if I want to copy data from another sheet(Sheet3) to sheet2 also then it should not delete the old data in sheet2. It should paste the data in sheet2 from the place where the data ends in sheet2. (Example: if data exists till A42 then if i copy the data from sheet3 to sheet2 then it should start pasting the data from A32. The same way for 20sheets ( sheet3,4,5,.....20).