I have a worksheet with data that needs to be copied to several different
workbooks. I have a macro that will copy the data correctly to one specific
workbook. What I need is to start the macro so that it asks me the workbook
filename. It then needs to be able to copy to that specific workbook (which
will already have been opened).
I don't know much VBA but am imagining that I need to name a variable with
the filename that the user inputs, then use that variable as the reference in
all of my copy and paste commands.
Does this make any sense? If so, how do I program VBA to ask for a
user-inputted filename?

Thanks!
--
Sara