Linking multiple worksheets data onto one combined page - Microsoft Community

i need spreadsheet project doing... want combine multiple worksheets onto 1 main page automatic updating.

at moment have 3 worksheets different sites, eg, uk, germany & france. have same columns in each sheet data varies. 

i want combine 3 worksheets mass list in if update data in uk page or add column on bottom, update main page

example of each worksheet layout:

proposed kit	invoiced yes/no	invoice no.	qty ordered	qty shipped	date	opp no.	site
handset	yes	1234	1	1	08/11/2017	4567	uk
licence	yes	1235	3	3	09/11/2017	1234	germany
handset	no		10	10	09/11/2017	9101	france

is possible?

fyi i'm not excel techy ... i'm winging it!

also, combine data onto 1 sheet, make table , add slicer. slicer show box buttons on worksheet let click 1 or more sites automatically have filter data on table based on button clicked.

this result in 1 worksheet in workbook can used both data entry , reporting.

Office / Excel / Windows other / Office 365 for business