I need some assistance.

I can use the formula =sheet2!L4 to bring data in from same workbook to
the front page of my spread sheet, but I want to be able to import
information into this workbook from another workbook.

Can someone spread some light on this without using a macro or vba? I
really just want to keep this as simple as possible?

Thanks