move information in different tables in sheet1 to a calculation in sheet 2

Please help me with this formula

I have a worksheet with plenty of tables, with plenty of information. And on sheet 2 I have a calculation. I want a simple comand as "double click" or something else. And than the line in the tables appers in the calculation.

E.G. Sheet1 a2, b2 and c2 appers in sheet2 e7, f7 and g7
Sheet1 a18, b18 and c18 appers in sheet2 e8, f8 and g8

is this possible?

Hi Kim,

Welcome to Excel forum.

Please share your XL sheets to us with expecting result.

Thanks
Ankur

Book1.xlsx

here you have a smal part of the workbook, tell me if you have problem With reading it.

i want al the first colum in the tables in sheet 1 to appears in the first colum in the yellow Box in sheet 2