Pull Values From Many Worksheets

I need to place a value in cell B on sheet 2 of a workbook. The value I need is stored in C10 on all other worksheets in the same workbook. The name of each worksheet is stored in Column A of sheet 2 (Rows 3 through 404). How do I get the value from C10 on each worksheet into the corresponding row on Sheet 2?

I have Excel for Auditors and there is code on page 201 but it is the reverse of what I need. I need to get the value from the worksheets as opposed to moving a value to the corresponding worksheet.

Example:

Sheet 2
Column A Row 1 = Worksheet name
Column B Row 1 = Need Cell C10 value from worksheet name referenced in A