Is it possible to covert multiple sheet excel into one?

Is it possible to covert a multiple sheet excel file into one sheet, and have the original sheet name as a column in the final sheet?

So if you have multiple sheet excel A and B where all sheets have the same column names, you combine them, add a column lets call it category and it will have value of A or B.

Can that be done using LibreOffice or gnumeric or any software available on Ubuntu or should I do it programmatically?