Open different workbook and store data to variables

So the code I posted should work, ThisWorkbook refers to the workbook the code is in.

The only thing you might want to change is ActiveSheet to make sure the data goes to the right worksheet.