Pasting Data From Multiple Worksheets into a single worksheet

Hello Gurus,

I don't know if this is possible, but I am used to the idea that when you highlight multiple worksheets and copy their data, it can only be pasted in such a way that multiple worksheets will be selected by Excel.
However, I am trying to make my work easier and faster. So I have this sample (attached) and I want to copy the data set A2 - A10 for the 3 worksheets "Life" "Hope" and "Assurance" and paste in another worksheet (in another workbook actually, I just put this Summary worksheet for you to understand my probable outcome).

So I want the data to be pasted straight into this summary worksheet so that they appear under the headings "Life" "Hope" and "Assurance" in that order.

NOTE: I don't want to link them with a formula because the data will always be pasted in another workbook.

Any help on this please?

Thanks in advance.

That'll be nice AliGW.

Please help move to the right section.

Hello House,

Help still needed on this.