Skip Multiple Rows when copying formula

PLEASE HELP!!!!!

New to forum - much appreciation in advance.

I have a linked formula tying spreadsheets together. The layout of the second sheet is different than that of the base sheet so I need to formula to skip 3 rows at a time from the base sheet.

Here is the linking formula in column B of the second sheet:
='[Inventory PLUS.xlsx]Sheet1'!A5


In the very next row of the second sheet I need it to pull from 3 rows down from the base sheeet (A8), or more precisely ='[Inventory PLUS.xlsx]Sheet1'!A8

In the next subsequent rows I need the formula to pull from (A11,A14,A17) always adding 3 rows from the base sheet each row moved down on the second sheet.

So, in essence I want my B column to go as followed:
B1 ='[Inventory PLUS.xlsx]Sheet1'!A5
B2 ='[Inventory PLUS.xlsx]Sheet1'!A8
B3 ='[Inventory PLUS.xlsx]Sheet1'!A11
B4 ='[Inventory PLUS.xlsx]Sheet1'!A14

and so on and so fourth, continuing down the sheet as there are a lot of different inventory and I am always adding more parts.

- If you have any input, it would be greatly appreciated.

Being that this is my first post I know I may have to explain better but any info you could send me would be greatly appreciated.

I believe you are referring to external reference to other workbook, so please confirm us whether the file will be in OPEN or will be in CLOSED mode?

if the file is open

Please Login or Register  to view this content.

^^ this will give you A5
fill down for a8, a11, etc

If the file is open then make use of the formula suggested by humdingaling in post #3

Make use of Indirect.Ext function of Morefunc Addin which will work with closed workbooks too...

Do a google search for downloading Morefunc Addin

sixth nailed it on the head
indirect only works when workbook is open

a different way of doing it
link the cells for about 3-4
goto the cell and take the "=" away
this will leave just the text for the link ...with this you can fill down to create the pattern

then have adjacent cell...ie in B1 ="='"&A1
fill down
copy and paste special values
now highlight the cells Find "=" and replace with "="

sounds like a lot but when you actually do it...its not that much

essentially what ^^ does
breaks down formula into text
fill based on text
reconstruct text into formula and refresh