How can I mirror one table in multiple worksheets

[biggynbp]

I have a table in which i track my tasks. I want to reference this table in multiple sheets. I have excel 2019 and can not use the filter function. The name of my table is task_tracker in a worksheet called Task Tracker 2 . Can this be done using formulas? one of the sheets i filter by status while i want to filter by task master in another sheet. I also would like to use a date range to filter in a third sheet. I've used query to place the table in other sheets but they do not update dynamically when new info is added to task_tracker. Can anyone please help? i am not familiar with VBA. Are there formulas that can accomplish this?

 

[Armstrong_N14]

why not use the "=" to each and every worksheet referencing all the data on your tasks table?

 

[biggynbp]

It does not update automatically. I was hoping to make the process dynamic

 

[Armstrong_N14]

maybe yours is manual?

 

[biggynbp]