Create a Summary Sheet from Multiple Sheets

Hi Guys!

Just want to ask for some help since i don't have the slightest idea on how to work with VBA.

My boss requires me to prepare forms for vouchers that we release to our suppliers.
I encode the details manually to excel with his prescribed format. each voucher are encoded on separate sheets on one file.
Now he requires me to prepare a summary for all the voucher forms which is now becoming a pain since i now hold 50+ suppliers. and each day i encode about 120 vouchers.

I found through this forum that there is a way to automate tasks on excel like preparing a summary sheet.
Could anyone please help me.

Thank you.