split Tables into multiple Tables for multiple sheets with different structure & arranging

Originally Posted by abdo meghari

but why you use range instead of dynamic lastrow ?

According to your both static attachments just using Excel basics 'dynamic lastrow' is useless !
As 'dynamic' has not much sense, last row is enough …