I have been given 19,000 seperate excel files, each has the data laid out it
the same way, but i need to get only a few selected pieces of data from all
of them into one file,

i though about a macro, but it only seems to work for the file i created it
in, and i had some issues with information being repeatedly pasted once the
data had been moved,
anyone got any suggestions?