3 posible tabs in closed workbook to place in one tab in curent workbook for search and edit

[DThib]

I have a rather convoluted question.
We are now running Excel 16 (365).
I am building from a VBA driven workbook, a new twist. A beginning GUI will provide 3 buttons to represent 3 Tabs(worksheets) in a closed workbook on the network. I want to draw a copy of certain rows from the chosen tab to populate a tab to use for searches and edits before continuing with the code already there.

What can I use to 1) call the closed workbook
2) Copy any information from the requested columns
3) place in the "Inventory" worksheet in the GUI workbook.

Can anyone give me a hand?

Running Excel 16 (365) in Windows10.

Thib

 

[DThib]

First of all, sorry for misspelling of possible in title.

Second, does anyone have any idea how to code for my query? If need more clarity, let me know.

Thanks,

D Thib

 

[DThib]

First of all, sorry for misspelling of possible in title.

Second, does anyone have any idea how to code for my query? If need more clarity, let me know.

Thanks,

D Thib

Anyone?
DThib