My spreadsheet has several worksheets plus one of these is a "recap" of all
other sheets. On my recap sheet - I'm trying to find the sum of a specific
name from all the sheets that equal to that specific name. The individual
sheets has the name in one colum with a total in another column.

I have defined a link that contains all spreadsheets with the range where
data exists. I'm having a hard time trying to firgue out how to write the
formula.

Example: Recap Sheet lists several po numbers:
A1 = 101-06
A2 = 102-06

Individual Spreadsheets keeps track of the amount of hours spent on each job
for a certain pay period.
I3 = 101-06 J3= $2000.00
I4 = 103-06 J4 = $1500.00