Is there an easy way to import data from mulitple files in a directory into a
single excel spreadsheet "X" ???

It would be ideal if speadsheet "x" were updated from this directory every
time that the excel spreadsheet "X" was opened.