Scheduling spreadsheet need to put cell value to a new sheet at a cell calculated by date

I have modified a template to help with production planning. For each product a line of data is created and stored in a new row on "Sheet1". Up to 34 rows of data can be collected.
The Data of concern falls at cells "Sheet1!G2:Q35" with the number of cells to be moved in column "F" and the number used for an offset to accommodate a "start Date" in Column E.
The scheduling is displayed on a tab named "DailyPlan" cells E2:AI35
This gives 31 days horizontally.
The goal is to place values of "f c b s p" into the correct cells of "DailyPlan" for a kind of Gant display of work to be done.
This should be calculated using "f" as the due date and the other values to the left.
crude idea:

c is placed at the cell "f" is at -1
b is placed a the cell "c" is at -1
and so on.
Is this possible or is there a different approach?