Need help with spreadsheets

I have created a spreadsheet in excel using powerquery and I am having trouble linking the data across different spreadsheets

I have limited knowledge with formulas

I have successfully created a table that updates when I refresh but I am having trouble building other sheets off of this main sheet(table).

I would like to build multiple sheets off of this table and have them update when the table updates

Unfortunately, my knowledge and experience with excel is limited