You can do this by writing VBA code.
If i understand your question correct a inputbox can do the work

"Louisville Cardinals" wrote:

I create inventory spreadsheets each day of the week. I have 3 productions
lines that each have a excel spreadsheet setup for their parts. The total
inventory from each line is copied into a master spreadsheet each day. The
individual prodution lines file name changes each day. Is there a way to
setup a macro to prompt for the file to pull information out of and then have
the info from the daily file copied into the master spreadsheet?

Thanks for any help!!