Convert raw data to layout

hi there,

I would want to know if it's possible to convert "raw" data from a table (or multiple) from a sheet into a report with a fixed layout I'd have made (like a model for graphs) in an automated way, would be better if it could adapt to small changes like number of rows for example.

it would for example :

-transpose columns A to E but keep a unique value for each one out of a table, in separate rows - draw graphs of G and H knowing F - add a big title - insert constant data to draw limit lines

Excel 2016 for now

See pictures in comment