Copy data from a column from 3 sheets of a workbook to the column of another workbook

Hi All,

This is my first post. I m a novice in VBA and I seek your expert help and advice for the following problem.


I have 2 excel workbooks, one named Source.xlsx which i receive on a monthly basis and other Destination.xlsx.

The Source workbook has 3 sheets, which contains numerical codes on Column F (in all 3 sheets), which can increase or decrease every month. I need to copy and paste the contents of Column F from all 3 sheets of Source workbook to Column B, Sheet 1 of Destination workbook one after the other, without copying headers. Can someone help me out with a VBA code to achieve this?

Thanks a lot.
Archer