Assuming:
  • you want to copy from the next visible sheet tab to the right
  • the tables share the same location on each sheet
  • that the cells on the master sheet are truly empty

then something along the lines of: 
Sub blah()
For Each cll In Range("A2:D9").SpecialCells(xlCellTypeBlanks).Cells 'adjust range to suit
  cll.Value = ActiveSheet.Next.Range(cll.Address).Value
Next cll
End Sub
I suspect the real life scenario is more complicated, so to get a better response, attach a file as close to your real life scenario as you can.