Create table using data created in other sheets

[csstew16]

I need to create a table with 2, 3 or 4 quotes created for different clients.
These quotes are calculated on a sheet based on many different variables. Because if the complex process of the calculation, each client has their own sheet. How can I pass those final numbers to a table that would have the headers name, q(uote)1, q2, q3, q4?

 

[arthurbr]

You probably could use Power Query

 

[csstew16]

I guess the rigjt question is.how do.i make it dynamic, so that when I make new sheets for new clients they get added to the main list

 

[alansidman]

 

[csstew16]

Thank you