Need to copy/link cells from a database to various locations on another sheet.

I'm working on automating/simplify a proposal I use. The proposal displays one item/piece of furniture per page, which includes the item #, description, and other details. I'm trying to avoid slowing scrolling through 30+ pages to input all the information. I would like to enter all the information in a database one sheet, and have info for each item appear/linked on another sheet. One item (row) will be shown on one page on the other sheet (proposal).

Each item's info will be on one row - Item 1.01 on Row 2, Item 1.02 on Row 2, etc. Columns will have specific info Item Number on Column A, Item Description on Column B, Quantity on Column C, etc. I then want to export each row's info to a particular page on another sheet - the actual proposal. So Cell A2 is "1.01" and I want that to appear on the proposal in cell E7. Cell A3 is "1.02" and that should appear on the other sheet in cell E65. There are 57 rows per page in the templated proposal sheet. So A4 on the data base would be linked with E121 in the proposal, A5 with E178, A6 with E234, etc. Other database columns will have other locations in the proposal, all in column E, with 57 rows between each page.


I started using this:

=IF(ISBLANK('Item Spreadsheet'!$A2)," ",'Item Spreadsheet'!$A2) so I would avoid getting a "0" if i left anything blank. Works great!

Until I get to page 2, then I need to change the reference to row 3 for the next item. Don't want to manually do this for 30-50 more pages. I've looked into trying to link the row # with the page number, or some formula that increase the row by one every time I copy to a new page. I'm a novice, and not familiar with macros, programming, or vbas. Any advice on how to proceed? I'm gonna start plugging in all the info manually, but would love to have something to automate the process.

A thought is to link the item number on each page to the database, then offset the other info on that page of the proposal by referencing the location of the item number in the spreadsheet (A2) and then pull data from across that row.

If I'm butchering this description, please forgive me, I'm happy to add any additional info needed.

I appreciate any advice, I've been searching for options for a while now and have stalled out.
Thanks in advance!