I’m trying to create an Excel workbook where I can populate an array with digits 1-99. The process I’m trying to create is to select a digit by clicking a button that would link to a VBA macro that copies the digit in a reference cell to the next cell I click. Here’s my VBA code:

I am very new to VBA and need a solution that would allow me to automatically compile the data from multiple tables in multiple sheets into one. To get into more detail: