I manage an Excel spreadsheet with extensive information on the countries of the world and their embassies in the U.S. I'll spare the boring details and give an example screenshot of what I want. Essentially, I'm currently managing a master file that I regularly update with changing statistics and information, and I also have a second file where I do the same thing, but only for certain countries (European Union countries and potential candidate countries, for example). The thing is, updating the second file leads to a duplication of work because I already update the stats and info (such as the last date my organization called the embassy) for all the countries. I'd like to know if it's possible to somehow create a second worksheet that displays only certain rows and when doing so, displays only select columns for those rows. My EU spreadsheet is barebones and contains only certain info, so I wouldn't need each tidbit for select countries/rows but rather just a few specific columns. Attached is a screenshot of a sample master file and sample second file that I currently maintain as two separate spreadsheets. Is it possible to somehow do this in a single spreadsheet through two workbooks, allowing me to only update the long list and have the second workbook automatically reflect those changes? Thanks!