I'm new here so please be gentle.

I have a task I need to complete.

I have multiple workbooks, all with multiple sheets of different names.

I wish to take the values form 2 separate cells (c4 and G26) in every worksheet and paste them into a list on a new workbook along with the name of the workbook/sheet they came from

E.g Final output will look like this. Data in column 2 has come from cell c4, Data in column 3 has come from cell G26

A1 A2 A3
Book1.xls!TimsData ABC 1234
Book1.xls!DavesData XYZ 5678
Book2.xls!AlansData XYZ 5678