Hi All,

Newbie and lost !

I have an excel doc with numerous tabs all of which have the same data in cells k2, f21,h21,f22 & h22 which i need a macro to pull out and put onto one summary sheet.

I have found something close to what i need here but cannot get it working for my example
http://www.mrexcel.com/forum/showthread.php?t=42414

Any help greatly appreciated as i really dont want to do this manually each month cos it takes ages

Thanks,
Saz