Confused by formulas.

Good afternoon,

I have a large quantity of ever expanding data on multiple worksheets in one workbook and I would like to count certain aspects and have them tabulated on another worksheet (report) of which I have made a copy from another work book.  Essentially creating one workbook from two that ultimately share the same basic data information.  I have attempted to use countifs sumifs vlookup and indexmatch.  What if any would be the best formula(s) to utilize to gather specific bits of  information from certain columns in the multiple worksheets and tabulate it on the report

Thanks in advance