What do you mean by 'auto fill'?
You can link data from one sheet to another --
Select a cell on the second sheet
Type an equal sign
Click on the sheet tab for the first sheet
Click on the cell that you want to link
Press the enter key.
To copy this formula across or down, select the cell with the formula
Point to the fill handle (the small black square at the lower right of
the selection)
When the pointer changes to a black plus sign, drag down or across
