Try:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))
+1,255)

-----Original Message-----
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


.