Hi Forum

I am trying to link cells from multiple work sheets to one main front work sheet (within the same work book). I would like to be able to make multiple copies of an outline information sheet that automatically transfers data from the front sheet - taking the information from the next line down for each work sheet.

I would also then like some of the information collated on each work sheet to automatically fill in on the front sheet, again on consecutive lines. Instead of manually going to each work sheet and putting in the links for each one, is there a way I can short cut it when I create the copies of the information sheet?

Also, is it possible to have the name of the tab on the work sheet (e.g.1, or 2, 3,4 etc. in this case) linked to a cell on the worksheet?

I have attached an example of what I am trying to do to help explain what I am trying to do.

Thank youlinks.xlsx