Help! importing data from other worksheets...
 

Atg the moment, i am using vlookup's and if's, sumif's etc to get info from
one spreadsheet to another and adding it up.
Is there any way i can make a macro to be able to drop in a file and have it
source the info from it automatically?
I am analysing timesheets and with vlookup's, i need to keep changing the
file names for where to look for the data. if i can't do the first, can i
make formulae that will look for a file that i only have to change one cell
for? I hope you understand what i mean! i'm not sure i do!