Power Query Table Consolidation & Data Validation List Values

[amazon_devil]

I have a workbook with several sheets. I have a power query that consolidates the values from those disparate sheets into one consolidated view. On each of those sheets is a column "Pass / Fail", and the values of that cell are derived from a dropdown data validation list.

When the query runs however, it is not pulling in the values that are being selected on the individual sheets.

I have tried searching for a solution, but I am either not looking for the right topic or I'm just doing something wrong. The only values it brings in for the column in question is "null".

let
    Source = Excel.CurrentWorkbook(),
    #"Filtered Rows1" = Table.SelectRows(Source, each [Name] <> "Consolidation" and not Text.Contains([Name], "Table")),
    #"Expanded Content1" = Table.ExpandTableColumn(#"Filtered Rows1", "Content", {"Process Area", "Script ID", "Epic", "User Story Title", "Actor", "Test Script", "Variations", "Pre-Conditions", "Expected Result", "Notes", "Tester", "Pass / Fail", "Comments", "Record Hyperlink"}, {"Process Area", "Script ID", "Epic", "User Story Title", "Actor", "Test Script", "Variations", "Pre-Conditions", "Expected Result", "Notes", "Tester", "Pass / Fail", "Comments", "Record Hyperlink"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Content1",{"Name"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Process Area", type text}, {"Script ID", type text}, {"Epic", type text}, {"User Story Title", type text}, {"Actor", type text}, {"Test Script", type text}, {"Variations", type text}, {"Pre-Conditions", type text}, {"Expected Result", type text}, {"Notes", type text}, {"Tester", type text}, {"Pass / Fail", type text}, {"Comments", type text}, {"Record Hyperlink", type text}})
in
    #"Changed Type"

 

[amazon_devil]

Nevermind. I've just found what was happening. Somehow the column header had been changed for the sheet I was looking into. Therefore Power Query couldn't match the column to be able to bring in the data...

*facepalm*