If the data in SS are fixed , use below steps:

1> Create a dataflow control tasks in ssis

2> For data flow task - place Excel Source and OLE DB Destination ....say (table test1)

3> In Excel Source data flow task - select "SQL Command" in Data access mode and put query like this

Select * from [Data$A3:D8]

Do like same for other two tables: test2 and test3

for test2 sql command: Select * from [Data$A12:D17]

for test3 sql command: Select * from [Data$A21:D26]