Pulling report data from a folder of sheets
I have several reports that need to pull data from multiple sheets. Those multiple sheets represent current projects. When choosing the sheets from which to pull data, I enter a checkmark for the entire folder, with the understanding that any new sheet I add to that folder will then be included in the reports. But when I put a new sheet in the folder, this doesn't happen. The sheets previously included in the reports remain checked, but the folder becomes unchecked.
Why is this happening? Is it by design? I was hoping to avoid having to open all my reports to add each new project sheet to the reports. This leaves an opportunity for errors and omissions.
Original sheet selection:
After new sheet is added to the folder: