linking Summary sheet with tab & data

I'm doing the example below using tabs with "project name" and in those tabs cells C2, C3, and C4 on each that I wish to automatically link to a summary sheet as follows:

Summary sheet

Project name

Project 1.....Org.Reg....Bus Value...Prob of Success.........Ave
Project 2.....=C2........=C3...........=C4...........................C2:C4
Project 3.....=C2........=C3...........=C4

The current formula used is: ='Project 1'!C2....'Project 1'!C3.....'Project 1'!C4

This requires typing names in Summary sheet project name column which does not always happen. Is there a better way to link/look-up automatically?

Thanks,
markingpmp