I'm trying to combine data from multiple excel sheets into a single table, and I'm looking to automate this as it seems to be growing every week. There is one specific census sheet, and about 4 or 5 other sheets that references the names in the sheet to particulary attributes. There is also a sheet that lists individual changes. I've been getting by using excel and v lookup but the logic is starting to get very confusing and I'm looking for a way to make the sheets easier. Additionally, sometimes the data is not the best but I need to filter through for additional changes.
Does anyone have any advice on
-pulling specific columns from the data sheets
-referencing those columns across multiple sheets to create a master sheet with the data I need
-adding filters so that the viewer can then select for certain attributes (name, location, amount of changes needed etc)
Any help either in the form of straight answers or resources would be appreciated!