Is there a way - in excel, to run SQL like queries on a sheet of data within the same workbook

E.g.
Sheet1 has data
In sheet 2, macro runs "SELECT * FROM Sheet1 WHERE Sheet1.Col1 < 5"

I know there is ways to simulate this (by looping data) but I need to do several different parameterised queries

Thanks in advance.