Is it possible to combine specific data from multiple worksheets? I have worksheets different people fill in so they're all identical as far as structure. I'm assuming this is more than just a simple formula.
Secondary question can specific data be pulled from other sheets? For example I have a list of inventory numbers but I only want ones that start with "GMP" pulled to a separate sheet.
Secondary question can specific data be pulled from other sheets? For example I have a list of inventory numbers but I only want ones that start with "GMP" pulled to a separate sheet.