Automate Excel Output Sheets

I maintain a single, ever-growing data table on one worksheet and need that information routed—without any manual copy-paste—onto five separate output sheets. Each of those sheets must refresh automatically and display only the rows that match its specific date range or current date view. Because the source updates daily, the solution has to be completely hands-off once set up.

I’m open to whichever approach makes the most sense—dynamic formulas, Power Query, or a tidy VBA routine—as long as the five sheets stay perfectly in sync with the master sheet every day. Please deliver the working file (or code module) plus a brief note that shows me how to trigger or adjust the process if my sheet names ever change.