Formula to duplicate a range of formatted cells based on data

[nico67]

Hi,

I need help to figure out the following:

In the attached example, first tab contains a range of formatted cells which I need to fill with the data of the second tab.

Due to the fact the data in the second tab is variable, meaning, could contain 10 lines of rows or 100 lines of rows,
I would like to be able to duplicate the range of formatted cells in the first tab to match the quantity of rows of my second tab, so I don't need to over duplicate the formatted cells.
The duplication can take place right under the first one.

Is it possible to do that, if yes could you please help me?

Thanks very much!