Hi Everyone,

I have a workbook containing multiple worksheets I want to collect data of Column A of some of the worksheets and paste all the collected data in a separate empty worksheet.

Hope you guys can help me