Use a Cell or Filename Value for Column Values on Combined Files

If you wanted to get or extract a cell value and use it for input into values for a table column or category, it's an easy copy and paste. However if this is something you do on a recurring basis or have lots of worksheets to do this with, it would be a prime candidate for some automation to combine the files. VBA would be one way of doing this but if you're a VBA novice like me, it'll take some time. Enter Power Query. With a few clicks and less than 5 minutes in set up, you can have an automation on what was a manual task before. This video will cover two examples: (1) where the value is coming from the actual filename (2) where the value is coming from a common area in the worksheet that is consistent amongst the files.