Separate sheets in Excel into separate workbooks

Hello

I have a huge Excel file with multiple sheets.
Is there a way I can split it into multiple files, one file per sheet?
I have tried block transformation but it it did not work because I do not know the exact number of sheets I will receive. 
Every month is different.

Thank you in advance,
Oscar

Hi Oscar

Provided that every sheet you have looks the same you can use the same approach as this video

www.etl-tools.com/tutorials/65-creating-...r-source-record.html

Instead of the ID field use the reader metadata transformation function.