Code to Extract data from multiple workbooks and Multiple sheet

Hi Guys

I have 5 Excel workbooks having 3 sheets each.All book containing same format and sheet name.
I need to compile all the 5 sheets in one master sheet of all matching sheet names between master and source sheets.

All my source sheet is linked to another file, what i need in master sheet is only formats and values and not the formulas.

Ex; Source 1 sheet1 has rows 4 to 10, source 2 sheet 1 has rows 4 to 15.
Expected Result: master woprkbook sheet 1should have rows 4 to 10 from sheet 1 of source 1 and rows 11 to 25 from source 2 of sheet 1 and so on..

Is it possible?

Thanks for any help

Hi Parth

I did go thru this before, none matches my requirement