Hi,
Attaching the input and expected output file.
Thanks and Regards
Reeta Gour
You can configure your input tool like the screenshot below. Bring in all your sheets via 6 input tools and the same workflow attached will union all the sheets together after cleaning them up.
Hope this helps, if it does please like this post/mark it as a solution.