Hello! I am an intermediate Excel user running Excel version 2205 (Microsoft 365) in Windows. I have a workbook containing twelve sheets. Each sheet is for a different booth in an antique shop and contains rows with information about the items in that specific booth. Some sheets have hundreds of rows. All sheets have the exact same column headings and formatting. There are no dependent cells. I want to create a Master sheet of all items and relevant information (rows) at a point in time (i.e., the data is static). I’d rather not copy and paste twelve sheets into one. Is there an Excel feature that will merge the rows of data from all twelve sheets into one sheet? I am open to VBA but prefer a built-in Excel feature if available.
