Since Alt1Lab is always coming from the same cell and (presumably) that is also true of alt2-5Lab, you could replace the variable names in the formula with the cell addresses from whence they come.

Or
ActiveCell.Formula = "='Bid Summary'!D17" + CStr(alt1Lab+alt2Lab+...alt5Lab)