Multiple reports. one big one sending information to smaller ones

Multiple reports. one big one sending information to smaller ones

When i import an xlsx table it only goes into the table im importing to.
what i want to be able to da is import to the main report and from there the information is linked to smaller reports 

big report contains:

Item nr 
Product Name 
Active ingredient 
ATC Code 
Formulation 
Strength 
Type of pack 
Pack size 
MA holder 
License (EMA or National) 
Country 
Price (Native currency) 
Price (Euro) 

where the smaller ones only contains one of each element for the lookup field option.

and maybe the option to not import duplicates?