Report with multiple sheets

Hi Smartsheet community, I am working on a report that compiles data from multiple sheets in a single folder. New sheets are added daily. Is there a way to automatically have the sheets selected update for the new sheets added daily instead of manually adding them? Thanks