Quote Originally Posted by JBeaucaire View Post
3) In the SUMMARY_Sample.xls workbook, each sheet we import needs a UNIQUE name. What naming structure do you want for the sheets that are being imported?
Please advise.

Also:

4) My standard consolidation macro is designed to simply open every file in the folder programmed and process them. Is that OK?

5) Each time the macro is run, should it:
a) clear the existing report of imported sheets so that the new report only has the new imported data?
b) simply ADD the new data sheets, so each time it runs the summary book just keeps growing?

6) If you choose 5b) then after each document is imported, should we mark it as "imported" in same manner so that it doesn't get imported a second time should the macro be run again?

We could:
a) make a change to the document name to indicate it was already imported
b) move the document to another folder, and "imported" folder so it's no longer in the "to be imported" folder
c) both
d) do nothing, you will handle the management of the files