In each source workbook (Workbook1, Workbook2), why not add this formula in a cell right above your sets of data, to identify the workbook for each set. Example:

In Cell A1 of Workbook1:
=cell("filename")

Then, in your summary file, link to Cell A1 in Workbook1, in order to pull that workbook's filename.



Do this for each set of data in your Summary.xls

This may not be the solution for you, though, as I did not understand this: "The missing element for me would be to have in the summary workbook a column that display the file name display in that fx area so I don't have to look up every cell to double check if I actually paste the right thing at the right place."

If what I suggested DOES work for you, then the caution is, using a link to a cell like this can be vulnerable to typos. You might copy data from Workbook2 into your summary.xls, but then accidentally grab a link to a different set of data in Workbook1.

Good Idea, I will keep that in mind for the future, now I found my solution with =formulatext

It work great and directly on excel 2013 and I had to create the function in 2010. Should work for previous too according to my reference

https://www.youtube.com/watch?v=wpRGTvhp1cY

Thanks anyway!