Is there a formula possible for me to return data transposed from multiple tabs?

Find attached example document. The information in each country tab is inputted manually, i would like the data to be collected together automatically. Returning transposed data from multiple tabs.xlsx