Linking workbook data

[Ada339]

Hello,

I'm trying to literally copy a worksheet (a) onto a completely new workbook (b) and have workbook (b) update automatically with any changes from worksheet (a). i don't care if the formatting from the worksheet (a) doesn't follow through to the workbook (b). I have been copy and pasting the link but I've noticed that doesn't update workbook (b) when rows or columns are added or deleted in the worksheet (a).

Is there another option to have a true copy of a worksheet?

Thanks!