Merging multiple sheets into 1 sheet

Is there a way to merge data from multiple sheets into 1 consolidated sheet? I know this can be done to generate a report, however I am trying to utilize the OnePager program to generate a "pretty" visual of my combined data and unfortunately OnePager cannot read in a Report from Smartsheet, it can only read in a Sheet.