Creation of summary in Excel

Hi, I am trying to create summary from three data tables. How can i achieve the same.

Any help would be much appreciated.
Thanks in advance.

Use inner joins on t1 and t3 and say this is t4
Then t2 left join with t4.
You get your output without total and add column qty to it with 1 as value

To get total use linq query to find sum groupby po number to get total of qty