Auto Populate Master Sheet with multiple sheets data

Hi

I need some help putting together a macro that will allow me to combine data from a number of different sheets into one sheet by pressing a button. I have attached my workbook showing the different tabs and the column headings. I will need to macro to recognise new rows added, as this will be used to track new sales opportunities. I will also need the ability to add new columns when needed.

I woudl be so grateful is anyone could help please?

Thank you

Haley