Making a Table
 

I need to be able to copy the cell values from multiple
files, same cell locations, different file name into a
master file buliding a master file table.... is there a
fast way to edit the file name with out having to
edit/find and replace the file name by manually typing the
file name and resulting in the replacing of the file
name...