Adding "Which page would you like to export to" option window to a macro

I have a sheet that calculate data into a single column. The macro for this will then copy the column from the calculation sheet to a daily sheet. I have 6 daily sheets and a macro button for each sheet. What I would like to do is do away with 6 buttons so that I only have one, which would open a little pop up window asking me which daily sheet I would like to paste to, I click the appropriate daily button on the pop up window and then the macro resumes function as normal. Is this possible?