Excel Workbook Summary

I have attached an Excel 2010 workbook with several sheets. Here is what I am needing: The "Summary Report" sheet is where the majority of the work needs to be done. *Needs: -Cell A1 has data validation based off the elements in sheet "c". This stays the same -I need to be able to populate all of the fields for the sections "C" and "H" respectively. -The data that goes into each row for these sections is separate into the sheets. So what I need (for example), is cell B5 to look at the item that is selected in A1 and the item in A5, and then display the corresponding data from the sheet C15B in cell B5. If A1=5826 which is the bottom item, then B5 would equal 88%. This would be the same for the rest of the cells B6 would compare A1 and A6 to the C15B sheet and display the correct data in B6). -15B and 16B for section "C" are both found in C15B. -15B and 16B for section "H" are both found in H15B. -SI for both sections C & H are found in C-H SI -PL and YTDP are both found in PL & YTPD. -Whatever element is selected in A1 should populate all fields for sections C and H. -Section V is to be ignored. -Finally, I need to be able to generate a clean report showing ALL data for each piece with both section C and H for ALL elements in A1. This is to be an actual complete summary for all elements in A1. -If you are able to come up with a better layout for the spreadsheet, this would be great as well. -FYI, I have been able to do this using the INDEX/MATCH functions within excel. I am looking for another way if possible.