Copying all the data from first column from 5 tabs and pasting it all in one colmun

[Imran Azam]

Hi Guys

how is everyone

I have an excel task where I need to automate a task which involves copying data from the first columns of 4 tabs ( column A:A from sheet1,sheet2,sheet3 and sheet4) and pasting all this data in to the column A on sheet5

Stacked one after another,

is this possible, if so how can I do this?

thank you for any help

 

[footoo]

perfect how do I change it os it pastes from cell A1 on sheet 1?

Only Sheet1 ?
Any other changes required - so that we do not have to continue doing bit by bit.