Link two workbook + format results as a table

Dear all,

I would very appreciate your advice on the best way to achieve the following:

- I need to automatically link a work plan in a new tab within the same excel file or in a new workbook +
- I need to be able to add slicers to this new tab or workbook so to filter results easily.

The problem here is that this information will be uploaded to (Microsoft) TEAMS which seems not to support complex functionalities or formulas. Therefore, the solution would need to be simple, easy and permanent (so, I guess macros etc. are not ideal in my case).

Thanks a lot for you suggestions.

Silvia