Excel for Mac: Combine Specific Cells and tabs from different Worksheets from different Workbooks into one Worksheet each respectively

[mgbb18]

I have 2 very similar goals:

1. consolidate in 1 worksheets 5 specific cells from dozens of different workbooks where each workbook contains the same 3 worksheets and the specific cells are always into the same worksheet and in the very same place;

2. consolidate in 1 worksheets 1 tab per workbook; in each workbook the tab has the same columns but different length.

Hope the above is clear but in case additional details are necessary will be happy to provide them

Thanks and regards

 

[mgbb18]

I tried with the formula and worked quite well; the only issue is that I had to manually enter the xxx number of the file for each line... it would be great if ion column a we could list the various doc numbers (i.e. the only parts which change into the source name (e.g. hereafter it would be "2" =[Workbook2.xlsm]Sheet1!$A$1). But anyway it worked and has been already a step forward.
many thanks

 

[mgbb18]

Many thanks. I'll test it on my mac and will get back to you with feedbacks.

Thank You Mike

Regards

m