Getting and Filtering data from multiple worksheet in the same workbook

[CJCabiles]

I am trying to get and filter the data from one of my worksheet and transfer that specific row to another worksheet. Let's say I have a main worksheet about land and aquatic creatures with 4 columns and I want to get the data from the main worksheet and filter that to a specific worksheet. The land animal row from the main worksheet will go to the land worksheet and the aquatic animal row will go to the aquatic worksheet.

I'm confused on how would this be possible. Can anybody help me? Thank you. 

MAIN WORKSHEET

LAND WORKSHEET

AQUATIC WORKSHEET

[#2 · Accepted solution]

@CJCabiles 

As variant you may use FILTER function (microsoft.com)

[#3]

It is working. Thank you!

[#4]

@CJCabiles , you are welcome