|If you are not familiar with the INDIRECT or ROW functions, look them up in the Excel help files or via a Google search.|
If your first formula is to be placed in Row 1, enter this formula:
=INDIRECT("'TQA " & ROW() &"'!$B$15")
Note that the single qoutes are enclosed within the double quotes.
If your first formula is in a row other than Row 1, you'll need to adjust the ROW() function with an offset.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.