Formula to match data
 

Sorry not the best subject line to describe what I am after - not even sure
if possible without using a filter/macro

Sheet 1

Col A Col B
Key Month
Dec
1 Jan
1 Feb

Sheet 2

Col A Col B Col C Col D
31/1/08 £1500 xxxxx xxxxx
30/2/08 £500 xxxxx xxxxx
25/1/08 £750 xxxxx xxxxx
15/12/07 £100 xxxxx xxxxx

Formula to show:-

Where 1 is entered in Key (sheet 1) - sheet 2 all data in that row is shown
for the specific month(s)