Dialog Box Query to copy sheet from one workbook to another

[emgall]

I've been stuggling with this and not making much progress. Hope you can help me.

I want a dialog box to open when the workbook known as calculation.xls is initially openned. The box would prompt for a customer name and a lot number. Then the macro would open a second workbook identified as lotnumber.xls in the directory C:\CustomerName. lotnumber.xls would contain only one worksheet. This worksheet would be copied to the first sheet in the calculation.xls workbook and then close the lotnumber.xls workbook.

Thanks much if you can help, I really appreciate it.