Sheets Question - Pulling through rows from other tabs

I have a tracker for my banking, and would like to seperate out the data based on which site the cost was attributed to - in Sheets my excel forumula wont work

I would like this to be my master and then have 2 separate for property 111 and 222, pulling across the entire rows into another sheet to create a P/L.

I have uploaded a workbook of the raw data and how I would like each tab to present.

delete all of the data from inside the table of sheet named 111 and 222. (keep the header row)

in cell B3 of sheet 111, enter this formula:

Please Login or Register  to view this content.

in cell B3 of sheet 222, enter this formula:

Please Login or Register  to view this content.

Thank you - I really appreciate it

no problem

if that answers your question, please click the "Thread Options" and mark the thread as [Solved].

Also, as you are new here, you may not be aware that you can thank those who offer help by clicking the * Add Reputation under their name in the post.