Hello guys!I am facing a little problem with my job in my effort to concentrate all the information in just one excel workbook.
So the thing is this: I have created a simple excel invoicing system.I will name tabs 1 up to 50(i would like to have 50 invoices per workbook so that i don't get confused)for my workbook.
In my example as you will see i have created 5 different invoices(1 to 5)
Is it possible to extract data on a different sheet as a pivot table?For example i would like to see:
1)Total amount of money per customer/and or destination
2)Materials bought from each customer/and or destination(e.g.customer "red" bought 500 metres of cable totaling 5000$)

I have attached an excel file with the examples...You are free to make any change you are comfortable with!I have no restrictions on the way each sheet is formatted as long as i print the general format that you will find there)EXAMPLE.xlsx

PS1:i know that i may ask too much,please forgive my ignorance!I just have a feeling that it can be done with a kind of pivot/consolidation method!
PS2:hope i posted in the correct place!
PS3:last but not least...any comments on how to improve my invoicing system is more than welcome!