Automating Time Series Calculation For Multiple Companies And Auto Generating Table

Hey all,

I've attached an excel spreadsheet which I need some help with please.

Sheet 2: Company name, revenue in period 1/2/3.... Green part represents the projections/expected figures that come from sheet 1.

Sheet 1: Uses a row in sheet 2 (done per company) and calculates the forecasts (column J and in green). Those figures are put into sheet 2 in the green part.

I need to repeat this per company (I have tonnes of companies but just wrote 3 for example) and need a quicker way of populating the table in sheet 2.

Can someone help me?