Copy a formula by dragging the fill handle

Hi.
I'm take data form one sheet to other and than use dragging copy.
On sheet1 where is data id is 1,2,3,4,5,... on finally sheet id is 4,30,56.
i use =CONCATENATE(Sheet1!A3," ",Sheet1!B3," ",Sheet1!C3,"/",Sheet1!D3," ",Sheet1!E3)
1.PNG
2.PNG
how you can see on finally sheet automatic take finally sheet id not sheet1
i use =CONCATENATE(Sheet1!A29," ",Sheet1!B29," ",Sheet1!C29,"/",Sheet1!D29," ",Sheet1!E29)

Hi slaptas, welcome to the forum! Perhaps you can copy the FORMULA (in the Formula Bar) rather than the CELL. Paste it in the first cell on the new sheet, then copy/drag THAT. Hope this helps. If not, in your next post, please show us:
1) the formula you're getting NOW, and...
2) the formula as you WANT it to be (Type it in if you have to)

Or better yet, attach a small sample workbook (NOT a picture). Remove any sensitive or extraneous info, just show us what cells contain your data and formulae, what results you want, and where you want them.

To attach a workbook:
Click Edit Post (or just start a new reply.)
Click Go Advanced
Scroll down to Manage Attachments and click.
Now just Browse for your file, then click Upload. Simple!


Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee