title: Grab data from certain, variable number of rows in another sheet
body: <p>I have searched and searched for a solution - but then I don't really know where to begin with this one. May not have been the most effective search.</p>
  
  <p>I have a spreadsheet that chronologically lays out tasks with responsible peoples' initials next to them (a leader and a backup). I am to make a new worksheet that displays this data differently and is person-based.</p>
  
  <p>Is there a way to have Excel seek out which rows have given initials (initials are in a cell of their own in the source) - in either the leader or backup cells - and then insert a formula like the below for those rows? This example grabs a bunch of text from different cells and puts it together (AB+CD, this place - doing this) in a different layout I'm using. What I need Excel to do is fill in the row (30, below):</p>
  
  <p>='AUDSCHED-COPY'!I30&amp;"+"&amp;'AUDSCHED-COPY'!J30&amp;", "&amp;'AUDSCHED-COPY'!D30&amp;" - "&amp; 'AUDSCHED-COPY'!E30</p>
  
  <p>I'd like to have a little section for each person, one on top of the other. Will Excel be able to adjust the whole sheet based on the number of times a person's initials occur on the other sheet?</p>