using fill handle - trying to get formula to develop proper repeat patern

[gwa]

I am attempting to use the fill handle of highlighted area on a worksheet that contains cells that extract info from another worksheet ... when I drag the fill handle,.... the cells that contain the formula that is referencing information from another worksheet are not getting populated with the approiate "next" cell of the referenced worksheet:
It's not incrementing in a "linear" fashion.
Example: WorkSheet 1 has rows of text with cell D8 having formula : ='WorkSheet 2'!A2,... with more rows of text (~37 rows of text) after that in WorkSheet 1
When I Highlight what I want to pattern copy in WorkSheet 1,... everything gets repeated properly but the info in the repeated pattern containg the formula does not have the NEXT cell reference in it,... it's getting incremented way too much cell D43 of WorkSheet 1 has the formula : ='WorkSheet 2'!A37 ...... I was expecting A3 ,... not A37.
I tried having three pages of manually inputting the proper cell references so that a pattern could be recongnized,... but when I use the fill handle to continue the process,.. that cell keeps getting the eronous cell input rather than the patten I would expect.
Is this fill handle function not usable for what I'm trying to do?
Any other way to do this ??

[Glenn Kennedy]

I think I know what you are doing, but it would help if you posted an example of your data in an Excel sheet. Remove any confidential information first...

[gwa]

where is the attach function on excel forum reply thread - so I can attach the excel file for you to see

[martindwilson]

to attach a sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[gwa]

Here is the sample ,.... where I have gone in and corrected the cells fore the proper referenced cell --- to show what I am trying to accomplish. see attachment

[Glenn Kennedy]

I got tied in knots for a while, but here it is.

[Glenn Kennedy]

I just noticed that a few more cells had the same copy-down issue. Hopefully they're all fixed now. If not - shout.

[gwa]

I got tied in knots for a while, but here it is.

Thanks for your expertise in helping solve this,.... You should definitely be elevated to Guru status !
I would have never been able to think of this or do it on my own.
Thanks again.