Originally Posted by Chuck

I have a workbook with several worksheets - one for every job, and each worksheet is named with the job name. I am trying to make a summary sheet with each job as one line, and I need to get a specific cell value ($C$4) individually from each worksheet. The value for each line must correspond to the correct job, so I have entered the job name in the first column of the summary sheet I'm making. How can I use the job name (column 1 of the summary sheet) to reference the correct worksheet when I call up the value of cell C4 from each sheet individually?