I have a formula (see below) that I want to be able to drag and copy so that the text in cells A1:A60 copies automatically into the formula. These are stock symbols. Where you see "SYM" is where I need the text in cells A1:A60 to go. Each cell has a unique symbol. Here's the formula.

=RediLINK|'L1'!'SYM;Vol'