Reporting from multiple sheets into a single resulted row

edited 12/09/19 in Smartsheet Basics

Is there a way to run a report that looks at 2-n sheets that uses a common column (primary key like), like a Row ID, to import the data from several sheets into a single row of the report?