Excel named range copy from sheet to sheet

I have an Excel question, I am wondering if there is an easy way to set up a clone or copy of a named range in one sheet to another worksheet in the same workbook. I need this to be done automatically, as the data comes in through a third-party software tool. I am not an advanced excel user and was hoping there would be an easy way to do this without macros, vba code, etc. Any suggestions? Thank!