I want to create a advanced filter that use multiple sheets same col as a
list range but I am not sure how to format the list range.

Example....

In my YTD Sheet I want to produce a unique list of values (CopyTo with
Unique Records flag on), based the values in Column C of Sheets Jan, Feb,
Mar, Apr, ....