title: Copy worksheet into different workbook replacing current data
body: <p>I am hoping someone can help me.</p>
  
  <p>I have two workbooks.
  Wb1 = FAC Trial
  Wb2 = ROMAN</p>
  
  <p>There are numerous worksheets within both workbooks. What I would like to happen is that the data in Wb2, worksheet named Format is copied into Wb1 worksheet named Format.</p>
  
  <p>The worksheet in Wb1 is already named and is to be updated on a daily basis from Wb2. The data in Wb1 worksheet Format would be overwritten each time.  I was looking that this would happen at the click of a Command Button.  Wb2 would not be open at the time of clicking the Command Button.</p>
  
  <p>I have found some code but it creates a new worksheet each time the code is run and I am unsure of how to change it to suit my needs.</p>
  
  <p>thank you in advance any help is greatly appreciated</p>