I have two spreadsheets in the same workbook. Users are entering data in a table of the Sheet1 and I would like to duplicate that same table in the Sheet2 dynamically. In other words, I don't want to manually copy all the values from Sheet1 to Sheet2. On the table of the Sheet2, I would do some filtering and sorting.
I am asking because I want to keep the amount of information visible to the use as minimal as possible. If a manager look at the spreadsheet, I want him/her to have a full view with all the calculation.