Use a Sheet as template to analyse exports

PJP610 

You've had quite a few views and no replies. I think part of that is that your description is a bit confusing.

I receive weekly exports of some data as excel sheets.  it's composed of multiple sheets, always with the same name and same columns. Only filename change.

I think what you're saying--but you need to confirm or clarify--is that

• you receive a single file, the name of which changes each week
• that single file consists of multiple sheets, all of them being arrayed identically, same columns (and rows?)

In order to analyse them, I've created a "summary" sheet with formula to take data on other sheets.

Example of formula : =history!AN2

So (again needing confirmation or clarification)

• you've created a summary sheet that extracts data from the sheets in that file you've received
• what's not clear is how many formulas you have that resemble =history!AN2 but differ in terms of cells to which they refer. And is the "history!" portion of that formula, a reference to a sheet IN the file, or to the file itself? 
• in other words, please be more complete on how this summary sheet works, how many different kinds of references you're making, to different sheets within that exported file, etc. An example of only one formula is an example of only one formula.

Now I'm looking for an easy way to "apply" of copy this specific sheet to every file that I receive. When I try a basic "copy/paste", I receive error message that formula cannot be copied and so only result are coppied... Which is not what I want 🙂

May some of you help me ?

It's possible that use of the INDIRECT function may prove helpful. But we need some more details on what you're working with, as hinted at by my questions above.

If the data you're working with are not proprietary or confidential, it always helps if you can share the spreadsheet(s) themselves. Post them on OneDrive or GoogleDrive and come here and post a link that grants us access to the file(s)