Macro to call another xls archieve

[Santino_X]

Hello, I'm doing a macro for a database, and it should take values from the last 4 databases so i can make a prom for the products. My question is:
Is there a code for opening the examine window to select a workbook, then copy the sheets I need into my actual workbook make the prom and erase the sheets I created?
Thanks