Consolidate data for creating visualization

[asafra]

I have a list of customers in 10 separate sheets on the file EXCLE .htblot contain: client name, identity card number, monthly payment, and commission. I would like to create one table where I could see all the fees for the client all the sheets togethe

TANKS 

ASAF 

[v-haibl-msft]

@asafra

It seems that this is the same problem with your another post. If not, please post back with more detailed requirements.

Best Regards,

Herbert