VBA Copy and Paste data form one workbook to another.. Problem is data change every w

[edmundchant]

Excel sheet given by information company
Capture.jpg

As you can the actual data that I need to extract only starts at row 38 and the column I need varies... sometimes I need extract last 2 column sometimes last 3 column