Good morning. Not quite sure what you mean by all fields. However you can try the following.
If the excel file layouts do not change, then create a pf with the formats. Export excel in .csv and place file in a QDLS folder, then use cpyfrmpcd to copy to a flat file with a record length that is greater than the longest excel row. Then use the cpyfrmimpf command to copy the data from the flat file to the final PF.
For each of the PF’s created, ensure that you have a key field for joining.
The flat file can be created without DDS.
Hope that this will work for you.