copy and paste from contiguous cells to non-contiguous cells using the = function

I am trying to enter contiguous cells which contain serial numbers from sheet 2 (Devices List) to Sheet 1 (Copier meter Log). The trick is that I need the serials to be placed every 17 rows on sheet 1.
For Example:
Sheet 1 A2 needs to equal Sheet 2 B3. Then Sheet 1 A19 needs to equal Sheet 2 B4 and so on in that pattern (see attached file). I have over 1000 serials to add and hope I don't have to copy and paste each cell onto sheet 1.

Any help would be greatly appreciated...

Do you want a formula to use in your mauve cell (A2, A19 etc.)?

=INDIRECT("'Devices List'!$B"&(ROW()-2)/17+3)

This formula will solve your problem. Then all you have to do is copy the blocks of 17 rows down the worksheet, and the next row from the Device List sheet will come through.

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by using the Quote
feature or mention their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

I am not familiar yet with how to utilize this. I guess that's Visual Basic? Thanks for the reply, though..

AMAZING!!! It works perfect! Thanks so much! I hope I can "Pay it Forward" one day!!! Thanks David!!!

You're welcome Shameus. Thank you for the encouragement.