From Excel data sources, need to create 5 different reports with different conditions

Hi guys

This is my first post in this community.

I was actually looking for some sort of design related guidelines for implementing my requirement with good effieciency.

I have 4 different excel data files from a third party source (TBL1,TBl2, TBL3 and TBL4)and I was asked to create 5 different reports with different conditions for each of the reports. All the tables can be joined by a Column which exists in all the tables.

Here some sample conditions

(Pull TBL1 Data -->If found in table TBL2.Clm1 and TBL2.CLM5=5

 Pull TBL2 Data --> If found in TBL3.CLM1 and TBL2.CLM1 and TBL4.CLM3=1).

Some of these reports may be using just 2 tables to genrate requested output and some of the reports are using 3 tables to generate requested output.

here are my questions:

1) Can we accomplish this requirements with single data model loading all 4 tables

2) Do we need to import all tables into data model and create a New Table with the requirements and use the new tables to populate the reports.

Please suggest a best way to accomplish above requirement.