Maintain - AutoFilter and Subtotals selection/layout?
 

Hello, in utilizing Excel's 2 built in tools of:

File - Filter - AutoFilter

....and...

File - Subtotals

is it possible to keep the specified selected items and layout for these in
kind of linking to other .xls files? New weekly .xls files (example:
Sales_September_20_2009_through_Septemeber_26_2009 .xls and so on...) will be
created each beginning of the week in having new weekly data in which
wondering how to use all weekly .xls files with different names instead of
doing it each time within each new .xls weekly file? Thanks in advance.