How to merge the most recent files (CALC)

Hello all,

I work with sheets from several files. All of them with the same structure and secuencial name, generated autotically everyday.

To ease the work, Im looking to a way to merge automatically the 10 most recent files from a folder into one simple sheet.



A -- B -- C


D -- E -- F

Merged file:

A -- B -- C

D -- E -- F

Already Im just doing copy-paste and I want to automatize this as much as I can.

Thanks in advance.