Import multiple jpg files in one file with file name in next cell

Hi,
I wonder if anyone can help me. Im looking to import a large number of image files into an excel sheet. Ideally Id like to be able to add the images in column A and the file name of the image in column B.
Is this possible? I have heard that its possible to do with Macros but have never used them before and cant find one that sounds like it will do what I need it to do.
Any help much appreciated.
Thanks
Sam

Anyone able to help me or point me in the right direction?
Thanks
Sam