Raw data (text) to populate monthly report

Hi there, I'm looking for a way to populate a monthly report (with raw data on a master sheet) automatically based on locations (each location on their own sheet) and filtering by date (if possible?). I tried a LOOKUP function but as I have mutilple values this doesn't seem to work as it only returns the first value. Help would be greatly appreciated!

Lots of ways to do this. Here's one.

=IFERROR(INDEX('Raw data'!A$2:A$73,SMALL(IF('Raw data'!$A$2:$A$73="Melbourne",ROW('Raw data'!$A$2:$A$73)-1),ROW(1:1))),"")

These are Array Formulas. They're a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

You're welcome...