Coding ? pull information from one Workbook to another
 

Here is my situation.

I have a spreadsheet as follows:
Col. A Col B Col C Col D Col E Col F
Col G thru Col P
Row 3 Jly Aug
Sep
Row 12 John Doe
Row 13 6059 Store A
Row 14 6060 Store B
Row 15 6061 Store C
Row 16 6062 Store D
Row 29 Jane Smith
Row 30 6077 Store E
Row 31 6078 Store F
Row 32 6081 Store G

I have another spreadsheet that gets emailed to me but is not formatted the
way I need it. What I want to do is write code in which all of the store #s
(60XX) and the sales are pulled into my spreadsheet for each manager. The
problem is stores do not stay with one manager. So one month Jane Smith
could be in charge of store 6077 and the next month John could be in charge
of it. Also new stores get opened each month as well and I dont know which
ones are added without manually looking at the spreadsheet. I am looking for
code that will take into account that the stores change managers and so so if
John Doe gets a new store a row automatically gets inserted and the new 60XX
is pulled in along with the sales. And on the other hand if a store is
taken away that row will be deleted. There is no other data in Col A in the
spreadsheet that gets emailed to me. Is there a way to write code that says
Find Text and pull store data into €œothersheet€� Until it finds Next Text (the
next text would be €œJane Smith€�) and then it repeats itself? Although not
shown in this spreadsheet here, there are 7 static rows between each managers
name and stores. This information must stay there. It is already formatted.
Although data is in these rows, there is no data specifically in Col. A in
these rows. Thanks in advance