When encountering inconsistent or missing data during consolidation, my first step would be to conduct a thorough review of the data sources to identify any discrepancies or gaps. I would compare the current data with historical data to spot any significant deviations or missing entries. For instance, if I notice a sudden drop in numbers where there shouldn't be, it could indicate missing data. I would then cross-verify these findings with the respective data owners or departments to confirm the accuracy and completeness of the data. Additionally, I would use data validation techniques in Google Sheets, such as setting up rules to flag anomalies or missing values. Once identified, I would work on correcting these issues by either retrieving the missing data or adjusting the inconsistencies, ensuring that the final consolidated report is reliable and accurate.