So I have multiple lists on multiple worksheets and need a new worksheet with
a new list that has all data from other lists.

Simple example: Worksheets of Week 1, Week 2 , Week 3, Week 4. Each
worksheet has a list created by list manager. Each list has the same columns,
but different number of rows (over 400). I need to create a new Worksheet
"Month", with a sortable list containing all columns, rows, and content from
all other lists. The Month list would need to reflect any changes on any
other list. If a change is made in the Month list, it would need to reflect
that change in the individual list. (The actual project is much more complex
and is not feasible to make it all one list.)

What is the simplest way to reference all content from multiple lists in a
single list?

Thanks.