I want to,

Extract text from only second row of all excel files in folder along with file name and update in a new file, with the text and file name.
(PS: the row is merged column cells)

Appreciate any help. Thanks!