Copying Subset of Information vs Copying a Whole Row

Our team is creating a process in which a subset of information from one sheet must be copied to a different sheet. What are some options to do this? I have considered a helper sheet with index and match formulas, data shuttle, automations, etc. Please advise the best practice for this.