title: Transform multiple sheets in dataframes in R
body: <p>Silly Question - How to improve this code??</p>
  <pre><code>my_data1 &lt;- read_excel(&quot;C:/Users/farj0/Downloads/Pilares_ranking_clp.xlsx&quot;, sheet = 1)
  
  my_data2 &lt;- read_excel(&quot;C:/Users/farj0/Downloads/Pilares_ranking_clp.xlsx&quot;, sheet = 2)
  
  my_data3 &lt;- read_excel(&quot;C:/Users/farj0/Downloads/Pilares_ranking_clp.xlsx&quot;, sheet = 3)
  
  my_data4 &lt;- read_excel(&quot;C:/Users/farj0/Downloads/Pilares_ranking_clp.xlsx&quot;, sheet = 4)
  </code></pre>
  <p>k = list(my_data1,my_data2,my_data3,my_data4) %&gt;% reduce(left_join, by = &quot;Município&quot;)</p>
  <p>Thank you!!</p>