If I have 2 workbooks, 1 called “workbook A” one called “workbook B”

They are both stored in the same folder in the same drive “x drive”

One of these spreadsheets contains data which is sensitive and therefore a company only workbook, the other is the copy that I send to customers. Some of the data is exactly the same across both worksheets which causes me duplication. Mainly names and costs.

Is it possible to transfer all data form columns A and E from “workbook A” to columns A and E in “workbook B” but keep a link so when the data changes on either, both workbooks are altered

Once again, step by step instructions are about the limit of my understanding.

ManyThanks,
Mark.