Very advanced links through excel to several workbooks
 

I am going barmy with this! I need to link several spreadsheets off of one
spreadsheet, a template sheet, which contains quite a lot of information.
Off of this one sheet I need to be able to link so that each time I enter a
new reference the other workbooks will begin another row. The catch is that
because it is a template I have only 1 cell to link off for a lot of
different references, I need the link to recognise that it needs a new
destination cell. Am I fighting a losing battle? I have tried everything I
can think of, does anyone else have a suggestion?