I have multiple lists on a sharepoint site and want to utilize the
data in Office apps.

I understand the sync functionality with excel, but I do not want to
sync the entire list, only particular fields of a given record.

For instance, a list with item number, item name, quantity, and
purchase date.

In a word doc, I want to select the item name from a drop down list
(populated by the records) and display the quantity and item number
on various places of the document. Even manually entering the item
name would be acceptable.