Hello generous people:

Can we use macro for
1. Opening many files in order to copy a range from the files
2. Copying the ranges to my file which I called a "data bank"
Our purchase orders was typed in the excel, and the name of the files is the
name of the project. I want to take the line items to be used in my file in
order to know name of the materials and Unit price.
To be more details I explain what I do manually:
1. Open the file name abc.xls
2. copy from range a1....e50 to my data bank
3. Tommorrow there is an additional range in the same file abc.xls range
a51..e75, I copied it to my data bank file
4. the next day there is a project PQR, so there is a file for all P.O's in
this project named PQR.xls, I operned it and copy say range A1...E40.. to my
data bank.

my question is how can I create an VBA for this routine job. There are 2
things variable.

1. File name could increased
2. range is the file could change/variable.

I appreciate your idea on how to solve the problem. Clould it be a prompt
parameter to fill in the name of the file and the ranges? in the middle of
the process of macro when it is running?

Many thanks,

Frank