Hi,
Thanks for that but not sure of the code.
Sheet 1, 2, 3 and 4 are all layed out like this:-

A B C
NAME DATE SIZE
Glenn 12.01 12
Dave 14.06 18

Sheet 4 has no info in it except for the headers (Name,
Date, Size) in row 1.
Sheet 1, 2 and 3 contains the data. I have a macro that
will display a inputbox and will then autofilter sheet1,
sheet 2 and sheet 3 to display the result of my input box.
What i am trying to get it to do is when sheet 4 is
selected it will show all the info from sheet 1,2 and 3 on
sheet 4