Hi, Im just new so sorry if this has been posted before.

What i need to do is link alot of info from one sheet to another for lots of sales. I know how to link the cells, (using =(spreadsheet name etc)) however i need to almost copy whole tables of info so I have one link at the top of my table that I need to fill into each cell with the last number of the cell increasing by one each time.

I know that if you have just a number you can either drag it or fill it down and it will increase like this, however I am having trouble finding a way to do this with a formula (i think it may be something to do with the number being in brackets)

At the moment I have two options, either fill THE SAME formula all the way down and go into each cell manually and change the numbers to link for the pages or take out the '=' and the last bracket, fill the formula which then changes the numbers and go back in manually and put the '=' and bracket.

As you can imagine this takes alot of time so I am looking for a quick way to do this as it is for literally hundreds of information cells. Is there a way to 'fill' the cells automatically or am I wastin my time looking?
Sorry for the long post I just had to explain it properly.

thanx in advance.