ReportFile will initially consist of a single sheet with a template of
a report on it. Code should be in this file. DataFile will arrive by
e-mail and be saved to disk. I will open ReportFile and run the code
which should do the following:

Open DataFile
1. Find First occurrence of "Stacie" in Column M
2. In that row, copy data in columns B, C, D, Q, & S as items
1,2,3,4,5 (an Array?)
3. Go to ReportFile
4. Copy Sheet1 as a New Sheet
5. Copy: 1 to A23, 2 to E23, 3 to C23, 5 to H8, and if
4=Consumer then E14=Consumer and C14 = 600100, else
(if 4=Mortgage) E14=Mortgage and C14=281200
6. Return to DataFile to Find Next occurrence of "Stacie"
in Column M
Repeat 2 -6 as many times as necessary
Go to ReportFile and
Print sheets 2 thru SheetCount
I couldn't see where to start/end the loop. Thanks for any help.