Copy Worksheet from Another Workbook based on Cell Value

You need to explain it well. i.e.

- which cells are to be copied from which columns from the closed workbook (source workbook)?
- Where you want to paste those values in the opened workbook (target workbook)?
- What is the path of the closed workbook?

And even providing answers to the above questions would not help much until you upload both the workbooks (Opened workbook and Closed workbook) with enough sample data in them along with the answers to the above questions.