Thread: Custom autofill

The problem is as follows: I have a worksheet named "Operation. " In it I have a head table, the values of the first row of the table are taken from another worksheet called "Foaie3. After this all other tables are not taking data in the worksheet called "Foaie3. How can I use Autofill, so the row below the head table next to me the value?
I tried but I can not take the next value. More specifically: if the row below the row heading is the first cell C4 (with reference to the worksheet called "Foaie3, respectively = Foaie3! A4) when using Autofill would be like to be second in the first cell - C5-reference = Foaie3! A5, but I get = Foaie3! A11.
How can I do to be = Foaie3! A5, but with Autofill?