Copy Data from worksheet to another one with VBA

[nelsonlauo]

Hello all,

I would like to copy data from Tables 1 to 4 (Data) and pastes to the specific columns in another worksheet (Expected Result).

Table 1 NO_ISSUED: from row 1 to 99 (from column A)
Table 2 ISSUE_DATE: from row 100 to 199 (from column B)
Table 3 NET_LIST_SA: from row 200 to 299 (from column B)
Table 4 PRICE_DIFF_PERCENT: from row 300 to 399 (from column B)

Sorry that I am new in VBA and knew that I should use array function to do so, but still can't find success.

Have attached sample Excel with dummy data. Thanks for your advice.