You need to give a LOT more information about what the whole process is here. And if possible post a copy of the actual spreadsheet or a mockup of it.
In general, it is easy to take data from one sheet to another...but "auto fill" can mean lots of things. So what exactly you mean by it needs to be spelled out. One row at a time data retrieval, vs a whole set of data occupying multiple rows? Etc. Don't assume we can read your mind; describe the full process here, what's the nature of the data you start with, on what basis it's to be "auto=filled" in another sheet, what kind of manual overwriting you need to do (and maybe even a bit of the "Why?")
