Hi, I have multiple excel files with multiple pages. A large % of lines have identical information. Is there a way to link these?

So for example line 1 column A has a part number of XXX. Everything else along line 1 relates to this part number. On other pages & other spreadsheets I want to duplicate the information relative to that part number. At a guess there are 2000 unique part numbers.