Get Headings in Array sheets at once

[RAJESH SHAH]

Hello experts
I am trying to paste the headings in the array sheets (created by the code). I have this code but it is giving me an error. Can someone please help me to edit the code and get the correct result. The code I assume is incomplete. I am not able to tell it which which sheet I am referring to for the range.
Thank you in advance.

[JohnTopley]

Try

Please Login or Register  to view this content.

[RAJESH SHAH]

Thank You John Topley.
It is perfect. You even changed the delete sheets with a single line. I have to extract data from B2B sheet and paste in the array sheets with multiple conditions. I wanted this much needed correct line which will help me though the rest of the code.

Please Login or Register  to view this content.

Thanks once again.