To advance the photovoltaic industry, highly efficient solar modules with reduced manufacturing and installation costs are needed amidst rapid market growth. To surpass the performance limitations of single-junction solar cells, multijunction configurations have been the focus of rigorous study. The current work showcases a comprehensive investigation into the development and optimization of four terminal tandem solar cell architectures, with a focus on exploring the most technologically viable impactful, and promising combinations of top cell materials (CdTe, GaAs, MAPbI3, and MASnI3) and bottom cell options (c-Si and CIGS). Through numerical simulations using the Solar Cell Capacitance Simulator SCAPS and meticulous analysis, considering crucial parameters such as bandgap, charge carrier mobility, and defect densities, this study aims to identify the most promising material combinations for achieving high-efficiency tandem devices. The findings reveal that when c-Si is used as the bottom cell absorber, the tandem device as a whole produces a higher power conversion efficiency than when CIGS is used. The top cell options, namely CdTe, GaAs, MAPbI3, and MASnI3 in conjunction with c-Si as the bottom cell, achieve maximum efficiencies of 27.23%, 29.31%, 31.66%, and 15.64% respectively. In contrast, when paired with CIGS as the bottom cell, the efficiencies slightly decrease to 23.76%, 26.43%, 28.45%, and 12.83%. Notably, the investigation involving 25%, 50%, and 75% Br-doped MASnI3 alongside c-Si reveals efficiencies of 16.59%, 14.94%, and 14.28% respectively. In the case of CIGS, the corresponding efficiencies for 25%, 50%, and 75% Br doping are slightly lowered to 13.78%, 12.17%, and 11.43%. The obtained results offer valuable insights that can guide future research endeavors and foster the development of more efficient and commercially viable solar energy conversion technologies in the field of tandem photovoltaics.