Copying Range from Closed Workbook

[reenendete]

Hi, I am looking to copy values from a specific range in a closed workbook/worksheet into a specific worksheet in the main workbook. The closed workbook is not in the same folder path. I am looking for the user to select the file.

The workbook name that has the values is named MTD with worksheet name Productivity
The main workbook name is Report Model with worksheet name MTD.

Any help or direction to get this done would be highly appreciated.

Thanks