Need help creating a sheet

Hi Everyone,    I need help creating a sheet that can pull yesterdays data from multiple sheets to one main sheet that we will be printing from. I basically want to streamline/automate the sheet a ...