A Macro to Fill data from Master table to individual sheet( Dynamic Table)

[Dilusha]

I have Following Master Table in Sheet1

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[TD]Column E
[/TD]
[TD]Column F
[/TD]
[TD]Column G
[/TD]
[/TR]
[TR]
[TD]Row1
[/TD]
[TD]Cus_Code
[/TD]
[TD]Inv_Date
[/TD]
[TD]Inv_No
[/TD]
[TD]Cus_Name
[/TD]
[TD]Value
[/TD]
[TD]VAT
[/TD]
[/TR]
[TR]
[TD]Row2
[/TD]
[TD]BBE
[/TD]
[TD]18/07/2018
[/TD]
[TD]SV4525
[/TD]
[TD]A CO .LTD
[/TD]
[TD]11899
[/TD]
[TD]1785
[/TD]
[/TR]
[TR]
[TD]Row3
[/TD]
[TD]BBE
[/TD]
[TD]20/07/2018
[/TD]
[TD]SV4531
[/TD]
[TD]A CO.LTD
[/TD]
[TD]16667
[/TD]
[TD]2500
[/TD]
[/TR]
[TR]
[TD]Row4
[/TD]
[TD]DSL
[/TD]
[TD]31/07/2018
[/TD]
[TD]SV4825
[/TD]
[TD]DS LTD
[/TD]
[TD]23261
[/TD]
[TD]3489
[/TD]
[/TR]
[TR]
[TD]Row5
[/TD]
[TD]EVE
[/TD]
[TD]01/07/2018
[/TD]
[TD]SV4401
[/TD]
[TD]E CO LTD
[/TD]
[TD]7142
[/TD]
[TD]1071
[/TD]
[/TR]
[TR]
[TD]Row6
[/TD]
[TD]EVE
[/TD]
[TD]15/07/2018
[/TD]
[TD]SV4513
[/TD]
[TD]E CO LTD
[/TD]
[TD]6987
[/TD]
[TD]1048
[/TD]
[/TR]
[TR]
[TD]Row7
[/TD]
[TD]EVE
[/TD]
[TD]21/07/2018
[/TD]
[TD]SV4625
[/TD]
[TD]E CO LTD
[/TD]
[TD]3107
[/TD]
[TD]466
[/TD]
[/TR]
</tbody>[/TABLE]


Column B is sorted & I have created sheets for each customer by the name of Cus_Code in same work book.

In sheet2 , I have following table.

Name Of Customer ...................
[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Serial No
[/TD]
[TD]Inv_No
[/TD]
[TD]Inv_Date
[/TD]
[TD]Value
[/TD]
[TD]vat
[/TD]
[TD]voucher No
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Signature ........... Date................

I want to fill above table & as per the Master table (Rows should be dynamics) & copy to the relevant sheet created with the name of Cus_Code.

Name of Customer should be filled .Column F ( voucher No) & "Signature ..... / Date ......Should be kept blank .

I use Excel 2007
please help me.