I am trying to get the specific file name as a column header. I need to extract the specific column from different excel sheets and write to another new excel sheet with the file name as the column header.
Here I’m just able to collect the different columns from different sheets with the same column header.
But I can’t able to get the file name as column header, which makes the user to understand on which date it was extracted in the column header.
Finally, I need the output like as follows
Please help me out