Sounds like a job for the INDIRECT() function! Let me know if that works or not.