Find, copy and paste from multiple sheets into one

Hi all,
This is what im looking to do:
I have the following data split into 269 sheets (67 rows on each sheet including the below headers):
Column A = Lot Number
Column B = Property Address
Column C = Owner
Column D = Owner Address

Example data is
Col A = LOT: 14 D/P: 1874
Col B = 21 Foobar Way NORTH PERTH
Col C = E Smith & J Johnson
Col D = 17 Conner Way PERTH

What i want to do is search through all 269 sheets for a value in Column B called NORTH PERTH and if found paste entire contents of each matched row (Col A to D) to a new sheet named NORTH PERTH

Please let me know if you need further info

Thanks for reading

you could use "For Each mySheet In Worksheets" or "For ii=1 to worksheets.count" to find values in all sheets, then insert the four columns into a new sheet.