Copy data from dynamic ranges and paste it another sheet

Hello,

I would like to ask some help regarding data copy/paste issue. In my sample file I have 4 worksheets, I want to copy and paste the data from sheet1 Range("F9:F" & lastrow) and from sheet2 Range("F9:F" & lastrow) to sheet4 Range ("B9:B" & lastrow) and after remove the duplicates and ascending sort.

I can do the copy/paste from sheet1 and paste it on sheet4 and remove the duplicates and ascending sorting but I do not know how to copy paste the data from sheet2 to sheet4?

Could somebody help me?

I attached the sample file.



Thanks in advance the help!