To ensure data accuracy and consistency when consolidating data from multiple departments into a single MIS report, I would start by establishing a clear understanding of the data requirements and standards for the report. I would coordinate with each department to ensure they provide data in a consistent format, using standardized templates if necessary. Next, I would perform data validation checks to identify any discrepancies or errors, such as duplicate entries or missing information. I would use tools like pivot tables and VLOOKUP in Google Sheets to cross-verify and reconcile the data. Additionally, I would maintain open communication with the departments to clarify any inconsistencies and ensure that any corrections are made promptly. Finally, I would document the process and any assumptions made to maintain transparency and facilitate future data consolidation efforts.