List of data

Hello, I am new to this forum and have trouble trying to create a formula for a set of data. Basically, I have a couple tabs all labeled. The first one is a title sheet, the next an index and the last one is a list of info I am pulling from. I manually fill out each tab of the index. From there I have multiple pages on the title page which I want it to identify what name I placed in the index and pull the address from the last sheet. So if I put "excel" as the name of the company it will look through a list to match that name and insert the address below it. I hope that makes sense. Any help would be great. I have been trying to figure it out but I keep on coming up with errors and it doesn't work ever. Thanks in advance.

O&M SUBMITTAL COVER SHEETS AND INDEX CUE testXXXXX.xlsx

Hope that attached. Let me try again. On the index page what I highlighted in yellow is what will be inputted manually. On the section titles tab the green highlighted cell will match each tab description on the index page. From what is inputted in the green cell on the section titles tab, I want it to reference the company name and address associated with that from the index tab. It will grab the supplier info from the supplier tab which has all the info listed, and place the name and address in the blue on the section titles. In theory the entire section titles tab will be auto populated once the index is filled creating section titles for each tab. Hope that is more clear. Thanks for the quick response.

Does is still not make sense?