Hi everybody,

I am looking for a way to do the following:

Problem description:

Within a folder there are plenty of Excel files (always random names-depending on content) so ‘*.xls’. Each of them has the same worksheet names, let’s say
/Sheet1/ Sheet2/ Sheet3/ Sheet4/ Sheet5/Sheet6/Sheet7/Sheet8 where Sheet3 and Sheet7 are graphs only.
I wish I could have a macro that collects all the graphs from multiple files into a master file
BUT..
Is it possible to locate them all (as jpegs) in one worksheet in an order as follows?

1st file’s name
Sheet3.jpg (6cm x 10cm) | Sheet7.jpg (6cm x 10cm)
2nd file’s name
Sheet3.jpg (6cm x 10cm) | Sheet7.jpg (6cm x 10cm)
…
…
…


For instance:

Let’s say I have a folder called ‘Market’ with 3 files:
Company1.xls, Company2.xls and Company3.xls.
Each of them files has sheets: Income/Income Graph/ Expenditure/Expenditure Graph.
I would like to make a final raport which should look like that:



Company1

Income Graph.jpg Expenditure Graph.jpg
(6cm x 10cm) (6cm x 10cm)

Company2

Income Graph.jpg Expenditure Graph.jpg
(6cm x 10cm) (6cm x 10cm)

Company3

Income Graph.jpg Expenditure Graph.jpg
(6cm x 10cm) (6cm x 10cm)


Could you please help with this issue? It would save me a lot of time and nerves.
Thank you in advance for your time and greatly appreciate your support in solving this problem for me.

Kind regards,
Anna