HLOOKUP and INDIRECT alpha numeric
 

Thanks to the help from a prior posting, I have the following calculation in
my spreadsheet:
=HLOOKUP(A5,INDIRECT("'"&$A5&"'!D2:H104"),3,FALSE)
This macro searches through several worksheets with lease numbers (e.g.
003403, 021456) to produce the results.
When I have a lease number that includes a letter (e.g. 003403R, 045789A), I
receive an #N/A response.
Can you please tell me where I've gone wrong and/or what I need to change in
my formula?
Thanks
Kelly