How can I combine multiple spreadsheets (cvs) into one master sheet using the terminal?

If I want to merge / combine multiple spreadsheets into one master spread sheet, I can just manually add them in LibreOffice. However this becomes cumbersome when dealing with a large number of sheets (>50).

Is there any way to automatize this, giving a list of spreadsheets as inputs and merging them all in one step?

EDIT:

All spreadsheets are in the same format: Same number of columns and rows, and same names.