Bernard,
I'm familiar with INDIRECT, but am not adept enough to get it to work. I
can reference data from the other worksheets and bring that data to the main
sheet, but I'm having trouble getting the data from a row without hard
coding the row into the formula.

Thanks,
Gary