I am creating an Excel file with several sheets on it. To make this as brief
as possible, I am (sadly) the most technologically savvy person in my
department. I need to find a way to create a macro that others can easily
change, so that when they change the file name, the macro code doesn't have
to be changed- it just has to be run.

For example:

I make "Assessment Template", and create a macro that works with it. That
macro has to open another Excel file, so that path is written in the macro
code. Just in this example, when I open this on another computer, I will have
to change the code- something other professors won't do.

What I was wondering is, is there a way to create a form in Excel that the
professor fills out before they run the macro. It would have the following:

the name of the data file
the name of the sheet the data is being transferred to
the number of rows information will be taken from from
the number of columns the information will be special pasted into

And so on...

Is it possible? If so, where would I find out how to do this?

Thanks!