I'm manually copying data from several workbooks to seperate worksheet in master workbook. The column of the data from the different workbook is fix but rows is variying. I would like to automate this task using VB.

What I would like to do is is open the master workbook and run the VB (using a command button). The VB will copy the required data from the different workbooks

I'm quite new to VB and have tried to write a few lines but it does not work as expected. Hope someone can advice how I can open a workbook and copy data from a specific worksheet to the current workbook.

Thanks and Regards