Search for specific text in multiple sheets and copy next line

[rtlane]

Hi,
Im a newbie with excel, so bear with me.
I have an excel workbook with a lot of sheets (around 600). I have 1 main sheet which lists all the sheet titles in one column. All the other sheets have the data I need to pull into the main sheet. So per the example below....I want to match the sheet title with the corresponding sheet then fill in the egress rate and the type. So during the search it will find Site 1 sheet then search for the name "port 1/2/8" and then copy the next line and put it into the "type" column for Site 1. I then need to take the egress rate number that immediately comes after that and put it into the "Egress Rate" Column. I dont care if its by formula or vba. Any help would be greatly appreciated.
Example:
Main Sheet:
Sheet titles | Egress Rate|Type|
--------------------------------
Site 1
Site 2
Site 3
Site 4
Site 5

Site 1 Sheet:
Port 1/2/8
MW-1233....................
*********xx
*********xx
*********xx
*********xx
egress rate: 123456

[p45cal]

In the attached a worksheet function you use as follows:
Capture3.JPG

[rtlane]

In the attached a worksheet function you use as follows:
Capture3.JPG

Thank you