Dear John,

Thank you so much for your very helpful reply.

I added a T function to the formula, and copied it down the sheet. It
worked beautifully!

=T(INDIRECT("Tracker!A"&ROW()))