Exporting a table to a new file and creating a wizard

[SertanCPH]

Hi all,

I have a very complex data workbook, and I would like to have a button that exports data from a table. Then creates a sheet with the export date and a few other fields filled by the user. 

I would like to create a wizard where the user clicks on a button and a dialog box opens where the user can select the date, fill in other data, etc. Then a new file is created with one sheet containing the data table and another sheet containing the user-filled information including the date information. 

Please advise how I can do that?

[#2]

Things like this can be done with VBA UserForms. If you don't have any experience with it, you might spend some time learning it.