My brother had a number of datasets that he wanted to import into a LibreOffice Calc file and then do some analysis on them.
This raised two issues.
- How do you get more than one file into a Calc file and
- How do you assemble data from different sheets into a coherent whole.
Here is a short video dealing with the first of those issues