HI

I have 10 spreadsheets (all with the same layout). I need help to do the following:
1. When I write in any of the 10 spreadsheets, it automatically appears on the first page/spreadsheet.
2. When I write something in the intersection between a row and given column, excel pins that row to that column. This means that when I use slicers to filter my columns, all the information in the rows that share an intersection with the given column, appears.

I hope this makes sense. In advance, thank you to anyone who can help