Lookup Help

[DRExcel515]

I have a tab in a spreadsheet that each month gets a brand new dump of data for 3 different mutual funds. For the month ending 11.30.17 the total number of holdings for all 3 funds was 533 and for 12.31.17 was 544 (they are listed in order... so all of one funds holdings are from say row 2-100, then fund 3 and so on all the way down). My point is that the total number of individual holdings and total rows of data changes each month.

I have separate tabs for each of the 3 funds that each month I make a copy of the tab and copy and paste the new set of holdings into the respective funds new month end tab. What I'd love to be able to do is have a formula that somehow goes into the tab that gets the new holdings for each fund dumped in every month and somehow pulls over the correct list of holdings for that fund (even if say one month one of the funds has 100 holdings and ends on row 100 and the next month has 88 holdings and ends on row 88). The example below is say where I would dump the holdings for the 3 funds each month. There are 3 separate tabs (one for each fund that would need to find all the holdings for each fund. Any help would be much appreciated

Fund Code	Holding
CRO	Holding A
CRO	Holding B
CRO	Holding C
CRO	Holding D
ICO	Holding A
ICO	Holding B
ICO	Holding C
ICO	Holding D
ICO	Holding E
NPT	Holding A
NPT	Holding B
NPT	Holding C
NPT	Holding D

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Chrisdontm]

In order to make a formula, we would have to know what the names of the tabs are, and what columns all the information is in, and where they are going.
( More info may be needed as well )